<?php
$sql = "SELECT count(*) FROM stompers WHERE 1";
$sql_result = mysql_query($sql, $connection) or die ("Could not get Query");
$row = mysql_fetch_array($sql_result);
$sUsers=$row["count(*)"];
echo "<br>We have <b>$sUsers</b> registered users.";
?>
This would be the best way (suggestions would be cool);
----- Original Message -----
From: "Mark Charette" <[EMAIL PROTECTED]>
To: "Philip J. Newman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 23, 2002 1:28 AM
Subject: RE: [PHP] return the amount of records in a mysql databace
> select count(*) as n from ... where ...
>
> -----Original Message-----
> From: Philip J. Newman [mailto:[EMAIL PROTECTED]]
>
> Can someone point me in the right direction to find out how i can return
the
> amount of records in a mysql databace ?
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
