Re: Re: NMax

count() is prefered over mysql_num_rows, because the later requires a full resultset to be tranfered, while the first doesn't. (so, the 2nd is more resource intensive if you don't require the resultset) nate@savingadvice.com wrote:

Yeah definitely use COUNT(*) or mysql_num_rows() function. Nate -----Original Message----- From: David Schlotfeldt [mailto:dmschlot@plauditdesign.com] Sent: Saturday, November 06, 2004 9:19 PM To: php-general@lists.php.net Subject: [PHP] 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