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
