I've got a dynamic dropdown on http://www.northjerseydirectories.com I generate the js using php and a MySQL database. The dropdown does what you're looking for. Since the dropdown is client side you either need to go with javascript, an applet, or have the person submit a form that loads the second box which is pretty clumsy. Fred Steinkopf
On Wed, 6 Mar 2002, Aron Pilhofer wrote: > So, if the user selects "mercedes", then the next box is "500Sl, 300Sc" and > so forth. If they select ford, then the second box has completely different > values? > > You'll either have to reload the page after the first select, or use > javascript or some other kind of client script. I don't think there is a way > to do it with PHP, but maybe someone else has an idea to help you. I hope > they do, because I need to do the same sort of thing, and I am trying to > avoid js at all costs. > > > > "Randy Rankin" <[EMAIL PROTECTED]> wrote in message > F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL">news:F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL... > > Does anyone know how I might populate a drop down box based on the users > > selection from a previous drop down box? For example, if I have a table > > called 'autos' with 2 fields, 'make' and 'model'. I select distinct 'make' > > and populate the first drop down box. Based on the user selection, the 2nd > > drop down box would be populated with the distinct 'make' for that model > > (ie; if the user selects Ford in the first drop down, the 2nd drop down > > would be populated with Explorer, Expedition, Ranger, etc.). > > > > Thanks, > > > > Randy Rankin > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php