Tælle hvad query finder

Prøv:

$query = mysql_query('SELECT picid, COUNT(picid) AS tael, SUM(karakter) AS samlet FROM wc_hotornot_votes GROUP BY picid WHERE tael > 10 ORDER BY samlet DESC LIMIT 10') or die(mysql_error());

Skal måske være:

$query = mysql_query('SELECT picid, COUNT(picid) AS tael, SUM(karakter) AS samlet FROM wc_hotornot_votes WHERE tael > 10 GROUP BY picid ORDER BY samlet DESC LIMIT 10') or die(mysql_error());

Unknown column 'tael' in 'where clause'.

Og med din første kode får jeg:
You have an error in your SQL syntax near 'WHERE tael > 10 ORDER BY samlet DESC LIMIT 10' at line 1

WHERE tael > 10
=>
WHERE COUNT(picid) > 10

You have an error in your SQL syntax near 'WHERE COUNT(picid) > 10 ORDER BY samlet DESC LIMIT 10' at line 1

Kode:

$query = mysql_query('SELECT picid, COUNT(picid) AS tael, SUM(karakter) AS samlet FROM wc_hotornot_votes GROUP BY picid WHERE COUNT(picid) > 10 ORDER BY samlet DESC LIMIT 10') or die(mysql_error());
while($row = mysql_fetch_array($query)) {


(Sorry jeg ikke har svaret før men mit net har været nede)

WHERE skal komme før GROUP BY.

Du kan se syntaxen her:
http://www.mysql.com/doc/en/SELECT.html

opret svar nogle?

svar