dropdown

[Keendev]

Hi, I need help.

I have a form and a 2 select dropdown that pulls data values in my database....

my example is State and Cities.

When user selects a state on the dropdown1, the dropdown 2 values(cities) will change depending on the selected state.

any advice?
thank you in advance.

 

[BabyJeffy]

Was the one post in

http://www.tek-tips.com/viewthread.cfm?qid=1374295&page=1

not enough?

Cheers,
Jeff


[tt]Jeff's Page [!]@[/!] Code Couch

http://www.codecouch.com/jeff/blog/

http://www.coedit.co.uk/

[/tt]

Make sure your web page and css validates properly against the doctype you have chosen - before you attempt to debug a problem!

FAQ216-6094

 

[MSRez]

You could do this with JavaScript instead by loading all sets of states and cities to the page to begin with. Alternatively, the states dropdown could act as a jumpbox and load a new page with different cities. Depending on the total number of results you have, I think the first of those options would probably be the more elegant from a user's point of view.

 

[vacunita]

I would have to agree, MSRez. You would need either Js, to repopulate the dropdown, or submit the first drop down, and re-render, the form to get the appropriate values in the second drop-down.

I would think the JS is the more seamless solution from a user point of view.

You might want to ask this in the JS forum here: forum216



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[Olavxxx]

Yes, combine AJAX (js) and PHP.
Here you can see one sample:

http://www.fornewbie.com/article/php/create_ajax_dynamic_drop_down_list_using_php_-_xajax.html

There are many AJAX libraries with many neat features.
Ps. I would pull the data from mySQL rather than defining what really would be constants.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster