Fastest way to find total count

[natio struction]

Hey Guys,

I was just wondering which way you feel is the best to find the total rows from a table.

This is what I usually use:

$query = mysql_query("SELECT `id` FROM `table`");
$total = mysql_num_rows($query);


Thing is when it brings out over a 1000 rows I would think there would be a faster way to do this.

Any feedback on this would be great. Thanks!



Edited 1 time(s). Last edit at 02/08/2006 07:39AM by natio struction.