List box - update another list box following single or multiple selections

[cerebros]

Hi everyone,

 

I'm a bit new to Ajax and have been trying to find an example online of something similar to learn from without much joy.

 

Basically I've got a form with 3 list boxes (using <select>). The first list box is for countries, the second is for counties/states, and the third is for towns/cities.

 

What I want to happen is that when the page loads initially the list box for countries is populated from MySQL using straight PHP, which I've done.

 

When the user selects a country I then want the counties/states list box to update with the counties and states for that country. This I should be able to manage from the little I've learnt so far with Ajax.

 

However, when it comes to populating the towns/cities list, I want the user to be able to select multiple counties/states and have the towns & cities within those states/counties populate that list.

 

Can anyone point me towards a good example of something similar?

 

thanks

 

 

 

[ChaosKnight]

Have you found a solution yet? I have to make exactly the same thing but I don't know where to start... Please help...

[cerebros]

Hi,

 

No not yet.  I've been concentrating on other aspects of the website I've been developing so I'll probably be looking into this again in the new year

[ChaosKnight]

Hi, ignace gave this link to me: http://remysharp.com/2007/09/18/auto-populate-multiple-select-boxes/  its for a neat jQuery plugin that will make you able to do what you wanted with the select element, one of the guys on that page commented and said that it also worked for a multi-selection, jQuery looks easy enough even though I'm a noob at it LOL... Merry christmas and a happy new year to you, and strongs with the project.