Collating results from MySQL vote
Can anyone think of a good way of collating results gathered during a voting process I've set up?
The way I've done it so far is that the user is presented with a drop down list of all the documents they can vote for. They select their five favourite docs from this list and submit their vote.
The entry in the voting table takes the form of this:
id, firstname, secondname, vote_1, vote_2, vote_3, vote_4, vote_5
With the ID number of each document being registered into each of the five vote fields.
So, that was the easy part. What I need to do now is collate these votes and display them in a meaningful way. I'm not asking anyone to write the page for me, I'm just asking if anyone has done something similar and knows of a good way of getting the results and presenting them in a decent fashion.
Thanks in advance :)