On Thu, 30 Aug 2001 08:16, Kevin P wrote:
> Hi
> I have counted some rows in MySQL and I need to know how to pull out
> the number of rows.
> "SELECT COUNT(*) AS myCount FROM Products"
>
> Thanks
> Kevin
$query = "SELECT COUNT(*) AS myCount FROM Products";
$result = mysql_db_query($database, $query);
$row = mysql_fetch_array($result);
extract($row);
echo $myCount;
might do the trick; unless I've left a syntax error in there :-)
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
I'm so broke, I can't even pay attention.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
