Dynamic States

[therealairness]

When you choose on an different Country from the list box, the selections of states/provinces changes from the state/province list box. Is this possible in php?

Please advise.

Dennis

[LordShryku]

Without submitting the form, you'll need javascript.

[therealairness]

In javascript, it can't access the database to get the list of provinces.

[LordShryku]

Then you may want to query the database with php to build the javascript array.

[mniessen]

You could check this site: http://worldstats.assemblysys.com

Hope that helps.

Michaël

[Gary_King]

thanks for the link as well

[therealairness]

In javascript, you can create a select list box such as list of US states. The problem arises when you want a specific state selected depending on the database. How can you pass the info from database using php to javascript.

[dnast]

No, you only use javascript to submit the selection to the server. After the sumbit, php can process it and pull further information from the database.

So when you submit the country, your php script will retrieve the states/provinces from the database based off the submitted country and you can build the second select box from that info. The same will go for the selected state/province and the retrieval of cities. Throughout the processs, the page will reload itself multiple times, but will add a category each time.

The link mniessen provided is a perfect example of this and is something I will be refering to when the time comes. You should really take a look at it. 🙂

[zapa]

This is what you are looking for: http://www.experts-exchange.com/Web/Web_Languages/JavaScript/Q_20913485.html

other javascript helps codes:
http://www.mattkruse.com/javascript/dynamicoptionlist/
http://www.devguru.com/features/knowledge_base/A100209.htmlhttp://www.hotscripts.com/Detailed/33597.html