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 "

Re: [PHP] Counting table fields having specific values

ww.chessish.com mailto:[EMAIL PROTECTED] - Original Message - From: rentAweek support <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 5:31 PM Subject: [PHP] Counting table fields having specific values > I have a table where the row named &quo

[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 =