Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199908

Re: [PHP3] Finding # of rows in table From: Adam Whitehead (adam <email protected>)
Date: 08/14/99

$res = mysql_db_query($db,"select count(*) from TABLE_NAME");
$row_count = mysql_result($res,0,"count(*)");

At 02:52 AM 8/14/99 -0600, David den Boer wrote:
>What is the quickest, least load on the server, way to find out how many
>rows are in a table? Seeing as this will be shown alot on my site, I would
>like to be able to limit the load on the MySQL server.
>
>Thanks,
>David.
>
>
>--
>PHP 3 Mailing List <http://www.php.net/>
>To unsubscribe, send an empty message to php3-unsubscribe <email protected>
>To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
>To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
>To contact the list administrators, e-mail: php-list-admin <email protected>

Regards,
Adam Whitehead
CEO - Netherworld Media
E-mail: adam <email protected>
Phone: +61 (889) 279 898
FAX: +61 (889) 273 889
Mobile: +61 (411) 241 120
Musicseek (http://www.musicseek.net) 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>