Re: [PHP] Re: NMax

[M. Sokolewicz]

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)
[EMAIL PROTECTED] wrote:
Yeah definitely use COUNT(*) or mysql_num_rows() function.
Nate
-----Original Message-----
From: David Schlotfeldt [mailto:[EMAIL PROTECTED] 
Sent: Saturday, November 06, 2004 9:19 PM
To: [EMAIL PROTECTED]
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

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