forms, php and mysql

[Anon]

I want to create a form that has 3 drop down menus.

The user selects the option of the first menu and onchange that cariable is used to search my database to produce the option list for the second drop down.

similarly the two variables produced are to be used for a db search for the final drop down.

can someone help

gordon

[nightowl]

Dunno for sure if this is possible without reloading the page. You would need, using javascript, use the onchange-method to submit the form, so that the other contents can be loaded, I guess. Correct me if I'm wrong.

[sarahk]

Bit tricky and don't shy away from javascript.

have a hidden frame which is reloaded with the option you want. eg getinfo?opt1=dinner

the getinfo script then returns a hidden form with the dropdown, or maybe a string in an input box. Your script takes the string and builds the second option list. That way you don't need to have the active screen refreshed AND you've queried your database.

regards

Sarah

[Anon]

go sarah!