I am still very much a beginner in writing php code and using mySQL databases. In order to teach myself more, I'm building a project (in my mind so far) to teach myself some skills.
What I want to do is create a little site for my fantasy football league. Basically, I want to upload the player scores each week so that I can use the data to write various reports (high point scorers, etc.)
So each week I'll want to upload to my database the points scored for each player (there will be 140 players to upload each week). Each player will be in the database and have a unique number to identify them.
So what would be the best way to upload the data? I guess I will write a PHP form to input the data manually, but how do I associate the unique ID for each player so that his data for each week get associated with his row in the PlayerID table? Do I have to create a dropdown list of all players in my database, and then pick him? That seems like a slow way to go.