Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text



#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