mysql_num_rows

[Bernhard Graaf]

Hi,

I have a problem with the command: mysql_num_rows(). The C-code looks like this:

sprintf(tmp_str,"SELECT * from adapter");
mysql_query(my,tmp_str);
my_result = mysql_use_result(my);
num_rows = mysql_num_rows(my_result);
printf("Anzahl Datensätze: %i\n", num_rows);

I'll got every time a counter with 0, but I have 4 Datasets in my table.
What's wrong in my code?
What I need is the number of entries in my table.

Thanks for help!