Results 1 to 4 of 4
Thread: Order by rating
Jan 17, 2006, 12:50 #1
- Join Date
- Mar 2005
- 0 Post(s)
- 0 Thread(s)
Order by rating
I have a table with five fields:
I want to order the items by their rating.
SELECT * FROM items ORDER BY rating DESC LIMIT 10;
SELECT * FROM items ORDER BY rating DESC WHERE numvotes > 5 LIMIT 10;
However, I would like it that the following:
rating: 4,3 (out of 5) numvotes 150
rating 4,4 numvotes 10
How would I be able to do something like that?