Re: Re: NMax

["M. Sokolewicz" <tularis@xxxxxxx>]

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@xxxxxxxxxxxxxxxx wrote:
> 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