Hi,


I know this question has been asked before. But I'm really stuck after several attempts:

I want to have a dropdown listbox (e.g. Country), by updating of which would in turn dynamically updates the list of a 2nd dropdown list (e.g. Province). The list info all comes from the database.


I understand that this requires incorporation of Javascript codes. I have failed in previous attempts. And want to confirm the correct approach to this.

At the onChange action of Country list, what action should I use?

Possibility 1: Should I be using a form submit action? Then, upon submission, the Province list box be refreshed and retrieve data based on the Country selected? - - - here, I have problem getting the value of the posted Country box. If the name of the dropdown box is 'Country', how should I get the selected value?

Possibility 2: Should Country box's onChange action ,instead of using form submit action, fire an event to create/re-create the Province list? I don't know if this is feasible? By that, will it be using Javascript to do, instead of using PHP to create the Province list?


Would like you experts' help. Appreciate if there is some working example scripts for better understanding.

thanks a lot,
jackling

There's a working example of this at Pnooka.org. I could give you that code, but you have to wait until i get back from my vacation next week to get it. I forgot to mention, that the code in question is used in the registration form. It might not work for all countries, since i haven't filled in every state info for all of them, yet.

Hi Pnooka!,


Thanks for your generous sharings! Yes, really appreciate you can share your codes for reference.

Wait for your response then. Have a nice vacation!

best regards,
jackling

Hi Fly.

I implemented something very similar in xasset..

Unfortunatly the download zip file is no longer there (lost during a hack a few months ago). You can still download the source from the CVS and have a look.