I have a "Pickem" football site that I use and I am trying to add a "Side" pool to it. I was able to add this so that is will post what I need to the database, but now i need a "standings" page to calculate the results. Here are the details:
1.) I have a pick sheet that the user will pick 1 Quarterback, 1 Running back, and 1 Wide Receiver each week. Each player should only be used one time and one time only. If the user has already picked this player, they should not be able to choose this player again.
2.) Based on the following parameters, each player will receive 1 point. If a QB throws for 275 or more yards, they are awarded 1 point. If a Running Back rushes for 100 or more yards, they are awarded 1 point. If a Wide Receiver catches for 100 or more yards, they receive 1 point.
3.) I will input a value for each week for each player into the database.
4.) Need to extract the results into a "Standings" page - this is written already, except for the calculations to determine the actual results.
To sum it up, I have some of the structure in place. Getting the information posted to the database is not an issue. The main issue is #4, and making it so only 1 player can be used once in the season.
Attached are 2 files, one is the "pick sheet" where the user will pick the QB, RB, and WR. The second is a partial standings page. The structure is intact, but the calculations are way off.
This is not a hard project for someone who is experienced with php/mysql. Alot of the code is already in place, so you are not starting from scratch. I understand this can be bad or good depending on how the existing code is.
Please bid accordingly.