whats wrong with this query ??

[PHPycho]

Hello forums !!
I am getting problems in this query :

"SELECT IF(COUNT() > 0, COUNT(), 0) AS total FROM table1 WHERE field1 = 'some_value' GROUP BY field2"

if there is no result the query is supposed to give 0 value but it gives nothing.
Can anbody help what went wrong in above query ?
thanks in advance to all of you

[rulian]

get rid of the if statement, I honestly dont even think it goes through considering count is determined by the sql and not as part of it, you can get a count without it, your sql will return 0 if you do a mysql_num_rows($SQL_LINK);
if you are tryiung t count the number of items grouped you can
$SQL_LINK=mysql_query("SELECT , count(field2) as total FROM table1 WHERE field1 = 'some_value' GROUP BY field2

[bogu]

rulian is right, if COUNT() returns 0 why do you use the IF statement? anyway it don't make sense your IF statement use ...