Is there a way, short looping through the DB, to find out how many entries there are?
Tanks :)
Printable View
Is there a way, short looping through the DB, to find out how many entries there are?
Tanks :)
I assume you mean rows in a recordset...?
You might be able to get it from the table properties but the easiest way would be to do
PHP Code:$rows_result = mysql_query('SELECT * FROM table');
$num_rows = mysql_num_rows($rows_result);
print $num_rows;
Doh, why didnt I think off that.
Cheers :D