displaying result of COUNT(*) FROM TABLE

[Anon]

I have a PHP-script which is supposed to display the result of a COUNT query for statistical purposes. The result should be the number of rows meeting the given condition, but I don't know how to display it.

I tried:

$result = mysql_query("select count(*)...",$db) ;
echo $result ;

Any ideas?

Thanks, Akos

[Anon]

$result=..........
list($count)=mysql_fetch_row($result);
echo $count;

[Anon]

select count(*) returns the count for everything in the called table. Have you tried doing something like:

select count(column_name) from table where column = 'condition' and column = 'condition'; <-- you can use multiple columns in the query even though you aren't actually counting in those columns.