determining number of rows in a mysql table
| From: | Andy B | Date: | Tue, 30 Mar 2004 05:48:47 +0000 |
| Subject: | determining number of rows in a mysql table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-181774@lists.php.net to get a copy of this message | ||
"Hmmm, have you ever actually tried it? And got the result you wanted?"
my screwup...forgot some code here... heres the whole thing that actually
works...(thats what you get for being in tons of different windows at the
same time)...
<?
include("conf.db");
mysql_connect($host, $mysqluser, $mysqlpwd);
$rows=mysql_query("select count(*) as count from users");
$count=mysql_fetch_array($rows);
echo $count['count'];
?>