try:
$strSQL = "SELECT COUNT(*) AS 'ItemCount' FROM my_table";
$result = mysql_query($strSQL, $db);
list($numberOfItems) = mysql_fetch_array($result);
echo "The number of items in the database is: $numberOfItems\n";
hTH
-----Original Message-----
From: Naga Sean [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 11:59 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Confuse w/ count function?
I try to use this count function, but no matter how.
I got this result from $t = Resource id #4
$t = mysql_query("SELECT COUNT(*) FROM my_table",$db);
echo($t);
any comments ?
-naga
--- Andrei Skorokhod <[EMAIL PROTECTED]>
> wrote:
>if you just need the number
>
>SELECT COUNT(*) FROM table where ................
>
>At 06:34 PM 3/30/2001 +0100, DC wrote:
>>Hi All
>>I cant quite work out how to count the number of rows in my mysql db that
>>match a certain critieria and the show that number numericaly in my pages.
>>
>>Checked books, php.net etc.
>>
>>Any help is appreciated
>>
>>Yours Dave C
>>
>>
>>
>>--
>>PHP Database 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]
>
>
>
>--
>PHP Database 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]
_____________________________________________________________
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database 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]
--
PHP Database 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]
