I run an online video game league for the PS2 NCAA Football 2005 game. In it, we have a vote (by all coaches) on who is the Top 25 teams of the week. They seem to have a hard time doing this if they are required to post their Top 25 on a message forum, so we are trying to find something easier to do. Basically, we want this:
[url removed, login to view]
How that works is there is a complete list of all teams (ours are different) and you sort them by moving them to the right. From there, you can sort the teams on the right by clicking the up and down arrows to put them in a proper order from 1, 2, 3, etc.
- The right side must not allow for less/more than 25 teams. If they have only selected less or more, the form (whatever it is called) will not submit. So, we want the ADD and REMOVE functions.
- We want the info stored somewhere where it will tabulate the totals for us to view in one sitting. In other words, the #1 team receives 25 points, the #2 team receives 24, the #3 team receives 23, etc... we want this tabulated on its own.
- We also want the voter to list their name so that we may see who voted.
All in all, we know nothing of databases so we would need this to be simple as hell.