Hi,
I am stuck at the start of a small project and I am not sure what would be the best way to go with a query etc.
The story is that I have a table with members predictions on a particular sport. They have predicted the top 5 places of each event (about 19 events in total). Some of these predictions have been entered more than once as some of the members wanted to change their minds on there predictions. Then I have a second table with the actual results from the events as the year passes. What I am trying to do is give each member (which could be many) 1 point for each correctly placed prediction. Then I would work on leagues etc.
I am new to mysql etc and I have been using phpmyadmin for my database work. I am just not sure is the best way to do this as all I can see at the moment is lots of queries and tables that is probably not necessary.
Any advice would be grateful.