Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

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