greater than for count(*)

[LucidParody]

I have this query:

$query = "SELECT count(*) AS cnt, AVG( a.vote ) AS vote, a.pid, b.id, b.imageLink, b.valid, b.gender, b.comment
		FROM voters a, photovote b
		WHERE a.pid=b.id
		AND b.valid='1'
		AND a.vote<>'NULL'
		$where
		GROUP BY b.id
		ORDER BY vote DESC
		LIMIT 0 , 5;";

I was wondering, how would I change it so that it only selects items that have a count (cnt) greater than a given number, like 30?

[bad76]

Hi,
in GROUP query you have to use HAVING:

SELECT count(*) AS cnt
...
HAVING cnt>30
...

I hope this helps