You could do it in a SQL statement

SELECT COUNT(*) FROM table_name;

This is less system intensive.

David


John Taylor-Johnston wrote:
I might add, I do this, think there must be a better way?

 $mycounter = 0;
 while ($mydata = mysql_fetch_object($news))
 {
  $mycounter++;
 }

John Taylor-Johnston wrote:


How can I calculate how many records I have in a table?
John

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to