why not:
select count(*) as counter from table
- Original Message -
From: Tyler Longren [EMAIL PROTECTED]
To: Chuck PUP Payne [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 1:02 PM
Subject: Re: [PHP] Count in PHP
$sql = mysql_query(SELECT * FROM
I am wanting to do a count in PHP. I want to be able to count the number of
records from a given database and display this count on the page. Can this
be done using PHP or is the sql thing?
Chuck Payne
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
it's best done in sql using select count(*)
but can be done in php by looping through the result set
-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 2:58 PM
To: PHP General
Subject: [PHP] Count in PHP
I am wanting to do a count
$sql = mysql_query(SELECT * FROM table ORDER BY whatever);
echo(mysql_num_rows($sql));
that should do it.
tyler
On Tue, 10 Sep 2002 00:58:26 -0400
Chuck \PUP\ Payne [EMAIL PROTECTED] wrote:
I am wanting to do a count in PHP. I want to be able to count the
number of records from a given
4 matches
Mail list logo