Yeah definitely use COUNT(*) or mysql_num_rows() function. Nate -----Original Message----- From: David Schlotfeldt [mailto:dmschlot@xxxxxxxxxxxxxxxxx] Sent: Saturday, November 06, 2004 9:19 PM To: php-general@xxxxxxxxxxxxx Subject: Re: NMax 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
