Populating a third form from the db

[JakesSA]

Here's the thing... in my DB I have 3 tables, called YEAR, MONTH and DAY. In my day table there are only 4 to 5 days that correspond to a month and year.
If a user selects a year and month from two drop down menus, how do I populate a third form (dropdown) with the corresponding days to that particular month and year.

I'm using PHP 4.2 and mysql as the db... so if anyone can please help or knows where there is a article on the net explaining this, I will appreciate it.

[alabonte]

If you want to have the third table to be dynamically filled, depending on the selection of the first two, you can:

-have the page reload, once the user has selected values from the first two tables. You can send the values along with teh reload and generate the 3rd table accordingly. (Use Javascript to automatically reload the page once they have made the first 2 selections selection).

-OR you could simply have the user submit the values from the first 2 tables, and then display their options for the third.

Good luck
andre @ performance technologies