[SOLVED] Help for MySQL Query

[blooddrainer]

Hello all, i have some problem.

 

I have field id, rating, category. Rating content integer, category varchar, id (autoincrement). I want to make query that get 6 result from the table with biggest rating. I have some query but there is some bug.

 

Here it is:

SELECT `gid`, AVG(`rating`),`cat` FROM `games_rating` group by `gid` having `cat`='trailers' order by AVG(`rating`) desc limit 0,6

[Barand]

try this (I left out "cat" as you know that will be "trailers")

 

SELECT gid, AVG(rating) as avrate
FROM games_rating
WHERE cat = 'trailers'
GROUP BY gid
ORDER BY avrate DESC
LIMIT 6

[blooddrainer]

THANKS  It works