TalkPHP - View Single Post

Orc · 11-08-2008, 01:44 PM

Quote:

Originally Posted by Tanax

So.. you don't want to post what you've done so far?

sql Code:

SELECT id, MAX(rid) AS toprating FROM `ratings`
GROUP BY id

Since i don't really have something "so far". I made this example. I hope this is a good example. ;P

The problem is, if I have an average of for example 4 "5" ratings, while as theres 2 "1" ratings.. It usually returns the 1 rating. But you have more "5" ratings.