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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
