Sweepstake results on a webpage - How would you do it?

[reggiep]

We are having a staff competition for the Euro 2012 where staff have to guess what the scores will be for each game in the qualifiers.

I am creating a simple webpage with a google docs spreadsheet on it.

I assume some whizzkid out there would have a php page pulling data from some mysql database but how hard would that have been to do?

 

I've got two years until the world cup to set this up so any suggestions?

[mac_shinobi]

How would you choose the winning person if say a few guessed the correct results, would you want it to loop through all data and find all the correct results and then from that data pick a random record and display the random record as the winner ?

[reggiep]

Nothing even that complicated!

They have to guess the scores of all the qualifying games, I have the spreadsheet already created like this...

 

Correct score is 3 points - correct prediction 1 point

 

Most points wins. If there is a draw the prize fund is shared.

 

I'm going to have to do some of it manually due to time constraints.

I'm not sure how I could automate the correct prediction even if the scores where different!