Problems with SELECT

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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

Site Timeline