Page 1 of 1

Dynamic Dependent Dropdown from MySQL

Posted: Fri Mar 03, 2006 1:50 pm
by dr00bie
I need to develop a dynamic dependent dropdown on my site. I have a MySQL database with 2 tables, State and County. The State table only has 1 column, State and the County table has 2 columns, State and County.

I would like to allow users to select a State and have the County dropdown only show the Counties in the State selected. Can anyone help me figure this out?

Thanks,
Drew

Posted: Fri Mar 03, 2006 2:01 pm
by nincha
once the user selects the state, use javascript to submit the information automatically. Now you have a variable to work with to dynamically change your html.

Posted: Fri Mar 03, 2006 2:09 pm
by feyd
might want to look for CoderGoblin's tutorial on this server.