Number of entries

[Gimlin]

Is there a way, short looping through the DB, to find out how many entries there are?

Tanks

[chrisjk]

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

$rows_result = mysql_query('SELECT * FROM table');
$num_rows = mysql_num_rows($rows_result);

print $num_rows; 

[Gimlin]

Doh, why didnt I think off that.

Cheers