Comboboxes
Posted: Mon Apr 14, 2003 6:09 am
Hi everyone
I have a problem that I have been trying to solve for a long time with no joy.
I am trying to create an online sports hall booking form. There are 3 comboxes, one for the activity, day and time. The data that I want to populate these comboboxes is stored in a mysql database.
I am trying to get this working so that when the user selects the activity they want it updates the day combobox with the days of the week, then then a day is selected I want to populate the time combo with the avalible times.
The tables that I have in the mysql database are:
activity
monday,tuesday,wednesday,thursday, friday - these have a list of time between 08:00-18:00
saturday, sunday - these have a list of time between 12:00-16:00
The problem that I cant sole is how to get each combobox to update when a selection is made,
Any help would be much apreciated
Thakns in advance
I have a problem that I have been trying to solve for a long time with no joy.
I am trying to create an online sports hall booking form. There are 3 comboxes, one for the activity, day and time. The data that I want to populate these comboboxes is stored in a mysql database.
I am trying to get this working so that when the user selects the activity they want it updates the day combobox with the days of the week, then then a day is selected I want to populate the time combo with the avalible times.
The tables that I have in the mysql database are:
activity
monday,tuesday,wednesday,thursday, friday - these have a list of time between 08:00-18:00
saturday, sunday - these have a list of time between 12:00-16:00
The problem that I cant sole is how to get each combobox to update when a selection is made,
Any help would be much apreciated
Thakns in advance