Ranking System

[marcus]

what would be a good way to start out a ranking system?

[Barand]

Supposing you have a table "item" containing items to be rated

item
--------
item_id
item_name

Createa second table to store your users rating scores

rating
-----------
id
item_id          // id of the item being rated
score
user_id          // optional - use if users must login and can only vote once

To get the top 10 rankings

SELECT i.item_name, AVG(r.score) as avscore
FROM item i
INNER JOIN rating r ON i.item_id = r.item_id
ORDER BY avscore DESC
LIMIT 10