Mike Try ... <? $res = mysql_query('select count(*) from names where not hide'); $row = mysql_fetch_row($res); echo $row[0]; ?>
Rich > -----Original Message----- > From: rentAweek support [mailto:[EMAIL PROTECTED] > Sent: 27 February 2003 17:32 > To: [EMAIL PROTECTED] > Subject: [PHP] Counting table fields having specific values > > > 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 > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php