Hi as you may of guessed from the screen name I'm new to this.
I need to develop a page that records tournament information and feeds it back into my database.
I have a drop down list that calls venue names from my database, another to enter the date field and a third to ask how many players results need recording.
what I need the form to do then is create the required number form input rows ( same as number of player results that need recording).
The form would end up with number of players listed 1,2,3 (these become their finishing positions) etc running top to bottom, next would be an input field for the players membership number, thirdly, a ldisplay box that looks up the membership number and displays the players name as a sanity check.
Then when the user submits the form it saves the data to the mysql database.
I can make a static form but how do I get it to change the number of form rows available to match the user inputted player results number?
Thanks for all advice offered.