RE: [PHP] Re: NMax
| From: | nate at savingadvice dot com | Date: | Sun, 07 Nov 2004 06:00:30 +0000 |
| Subject: | RE: [PHP] Re: NMax | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-201399@lists.php.net to get a copy of this message | ||
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php