HI.
I am creating a fantasy sports website, and am currently working on the admin side, so my employees can access the site and update player stats.
Now, I am currently printing a table of all players who belong to a particular team on the update page, with current stats. And below each stat, have a drop down box, so the admin can select how many to add to the current stat (representing this weeks new figures). The drop down box defaults to 0, and goes up to 5. The Admin puts into all the drop down boxes the correct figures (or leaves it at 0) and presses submit.
There may well be 20-25 players on this page, all requiring 10 updates, so there will be around 200 drop down boxes.
Now, I need to go through each player, and find the $_POST variables which relates to this guy, and update the database.
But I am not sure how to do this. I know how to do it for one player, but it seems complicated when putting several players into the mix.
What would I call the drop down boxes? Should they all be part of one form, or have 1 form per player?
How would I code the getting details from POST in the next page?
In the end, I think it is the scale of it that is confusing. Any advice is appreciated.