Hi Brent, I believe this is the way to go, but since I'm not a javascript guy I would like to get some php help for doing this. I you know some javascript can you please post some code for this task? Someone else proposed to query ALL the information from the database to populate the javascript code to be used but I disregard this since the data from the database is pretty big and a lot of user accessing at the sime will put the load on the roof. I'm sure there is an easier way to go.. Thanks a lot!
Francisco -----Original Message----- Using a combination of javascript and php this is easily done. Below is just a way off the top of my head. There are probably simpler ways of doing it or even more elegant but again this is just off the top of my head. You would populate your first dropdown box by whatever method. Then you would do an onselect javascript event to submit the form, the php code would check to see what "step your at" by seeing which select form field was submitted and then take the value of select form field , query against the value, and then use the results to populate the other select form fields. Wash, rinse, repeat. -Brent ----- Original Message ----- > Hi All, > I'm trying to generate a PHP page with 3 or 4 dropdown menus, each of one dependant upon each other, that means: > #2 dropdown should change upon selecting something on dropdown #1, #3 should change based on the selection at #2 to finally submit the desired query. Each dropdown menu should be generated from a mysql query based on the previous selection. > I need to generate mysql queries based on each dropdown selection and the page should reload the content for the next dropdown menu. I couldn't yet figure out how to accomplish this. > Let me know if I make myself clear enough :) > Any help is very welcome!! > > Thanks in advance, > > Francisco > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php