Re: [PHP] 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) [EMAIL PROTECTED] wrote: Yeah definitely use COUNT(*) or mysql_num_rows() function. Nate -

RE: [PHP] Re: NMax

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_nam