Re: Counting table fields having specific values

if ($array = mysql_fetcharray($result)) { echo $array["SUM( hide = 0 )"]; } although for readability I'd prefer an " AS sum_hide " in the query and then use $array["sum_hide"] in general for reading from a mysql result ... // for a single return row (or the just the first row) if ($result = mysql_query("...")) { if ($array = mysql_fetch_array($result)) { ... } } // for multiple return rows if ($result = mysql_query("...")) { while ($array = mysql_fetch_array($result)) { ... } } Tim Ward http://www.chessish.com mailto:timward@chessish.com ----- Original Message ----- From: rentAweek support <support@rentaweek.org> To: <php-general@lists.php.net> Sent: Thursday, February 27, 2003 5:31 PM 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 > >