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 ----- From: "Francisco Puente XFMP (QA/EMC)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 30, 2004 1:42 PM Subject: [PHP] PHP- Dependant dropdown based on Mysql queries > 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
