Counting table fields having specific values
| From: | rentAweek support | Date: | Thu, 27 Feb 2003 17:31:47 +0000 |
| Subject: | Counting table fields having specific values | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-137434@lists.php.net to get a copy of this message | ||
I have a table where the row named "hide" can have a value 0 or 1.
I want to obtain a count of all the rows where "hide" has value 0.
The following works on mysqladmin:
SELECT SUM( hide = 0 ) FROM
names LIMIT 0, - 1
Giving
SUM( hide = 0 ) 7
The PHP script statements generated are:
$sql = 'SELECT SUM( hide = 0 ) FROM names LIMIT 0, -1';
$result = mysql_query($sql);
What assignment statement do I need to write now to obtain the SUM value as shown by mysqladmin please?
TIA
Mike