Dynamic forms
Posted: Fri Nov 23, 2007 8:04 pm
Hello everyone. I'm new to php programming and have several questions about forms. I'm curious to see if what I want to do is possible before I invest alot of time to piece the code together. I'm putting together a web page for my baseball league as they don't have any at the time of this post. I'm also using MySQL to hold all of the game dates, game locations, home and visitor teams. I want to add a dynamic form to my administration page to allow the league director or myself the chance of changing a game date, location, etc. So here it goes
1) I would like to access my MySQL database to populate a list on my form for the game dates available. No any date, only the dates already pre-entered in the data base.
2) When a particular date is selected, is it possible to populate three other form list entries with the corresponding location, home team and visitor team for the selected date. This would provide an immediate visual to the director and/or myself that the correct row is selected (however, this is not necessary).
3) I want to populate the lists for location, home team and visitor team with the DISTINCT code to select the corresponding info only once. I could easily hard code the values but would like the flexibility for adding/removing teams in the database in the future.
4) Once the date, location, team home and team visitor have been adjusted, I need to change the old dates team home and team visitor to "OPN" to allow us to know it's availability.
Thank-you in advance.....
1) I would like to access my MySQL database to populate a list on my form for the game dates available. No any date, only the dates already pre-entered in the data base.
2) When a particular date is selected, is it possible to populate three other form list entries with the corresponding location, home team and visitor team for the selected date. This would provide an immediate visual to the director and/or myself that the correct row is selected (however, this is not necessary).
3) I want to populate the lists for location, home team and visitor team with the DISTINCT code to select the corresponding info only once. I could easily hard code the values but would like the flexibility for adding/removing teams in the database in the future.
4) Once the date, location, team home and team visitor have been adjusted, I need to change the old dates team home and team visitor to "OPN" to allow us to know it's availability.
Thank-you in advance.....