RE: [PHP] Counting table fields having specific values

Mike Try ... 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

Re: [PHP] 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 =