User sumbitted top 5 and sort by popularity
- by Bundy
Hi,
Database setup (MySQL)
table: top_fives
id, uid, first, second, third, fourth, fifth, creation_date
1, 1, cheese, eggs, ham, bacon, ketchup, 2010-03-17
2, 2, mayonaise, cheese, ketchup, eggs, bacon, 2010-03-17
Users can submit their top 5 of a certain subject. Now I would like a summary of the top fives ordered by popularity.
Each column has it's own point value. column 'first' is rewarded 5 points, 'second' four points, 'third' three points, and so on...
So, in my example it should be something like this:
1 Cheese (9 points = 5 + 4 -> 1 time in 'first' column and 1 time in 'second' column)
2 Eggs (6 points)
3 Mayonaise (5 points)
4 Ketchup (4 points)
5 Bacon (3 points)
6 Ham (3 points)
What would be the easiest solution (PHP) for this kind of situation?
Thanks in advance
