Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

192.168.1.41:8000, Www.xxxcon., %s wwwxxxcon, %s wwwxxxcon, www.xxxcon, xxxxdup, bitlord outgoing port settings, ckowwwxxx, 192.168.1.41:8000/nor-482.html, php.ini "Unable to initialize module"

Links

XODOX
Impressum

#1: Problems with SELECT

Posted on 2007-07-18 09:11:16 by Richard

I am having a problem with SELECT. The table has 3 rows. I am using
the C api. Here is my C code.

count = mysql_query(my_db, "SELECT * FROM accounts");
er = mysql_error(my_db);
res = mysql_use_result(my_db);
num_row = mysql_num_rows(res);

count is returned as 0 (no error)
er is NULL (no error)
res is trturned valid
num_row is returned as 0

I have full permissions to the data base and its tables. I can retrieve
data from other tables in the database.

Does any one have an idea as to what is amiss here. I can add to the
table and get the correct error when I try to add or update the table
with duplicate key fields.

Thanks Richard

Report this message