[SOLVED] SELECT TOP 10 rating

[rocoso]

Im trying to get the TOP 10 results of the rating_id. 

 

This sort of works but i get double results from rating_id.

"SELECT rating_id, rating_num FROM ratings GROUP BY rating_id ORDER BY rating_num DESC LIMIT 10"

 

this is the table

CREATE TABLE `ratings` (
`id` int(11) NOT NULL auto_increment,
`rating_id` int(11) NOT NULL,
`rating_num` int(11) NOT NULL,
`IP` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

ID

rating_id

rating_num

IP

1 345  5 192.168.1.7

 

2 123  3 192.168.1.7

3 345  3 192.168.1.7

 

 

 

 

 

Ive tried variations of counting rating_id, just cant seem to figure it out.    Im new to this...

 

 

 

[Barand]

Sort them by the average rating num for each rating id

 

SELECT rating_id, AVG(rating_num) as rating

GROUP BY rating_id

ORDER BY rating DESC

LIMIT 10

[rocoso]

SELECT rating_id, AVG(rating_num) as rating FROM ratings GROUP BY rating_id ORDER BY rating DESC LIMIT 10

 

I added the FROM ratings.  It seems to be working YEAHHH  !

 

thanks

[Barand]

 

I added the FROM ratings. 

 

Oops!

[rocoso]

YOU ARE A GENIUS!!!   

 

thanks