RE: [PHP-DB] How to find out the number of rows in a table?
| From: | Rick Emery | Date: | Thu, 24 Jan 2002 16:42:38 +0000 |
| Subject: | RE: [PHP-DB] How to find out the number of rows in a table? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16153@lists.php.net to get a copy of this message | ||
SELECT count(*) AS ctr FROM mytable;
-----Original Message-----
From: Andy [mailto:news.letters@gmx.de]
Sent: Thursday, January 24, 2002 10:36 AM
To: php-db@lists.php.net
Subject: [PHP-DB] How to find out the number of rows in a table?
Hi there,
I am trying to find out the number of rows in a table. The mysql docu says
there is a mysql_num_rows statement but it requiers a sql statement in
front. How could I do this more efficiently? Can anybody make an example,
please? I am sure that there is an more easy way.
Cheers Andy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net