dynamic list/menu to a list/menu

bealot

Hello,

I do have a form in which it has several list/menu. what i want to implement is the user must first select a list/menu value, after the value has been selected the other list/menu will update its value using the value of the user selected.

ex. on the first list/menu (accomodations)the values are:
de luxe
resorts
pension house

if the user will choose "de luxe". the values of establishment list/menu will query data using "de luxe" value so the value of establishment will display all the names of the establishment who is offering de luxe accomodations

its just referring the values of list/menu thru another list/menu

Any help is highly appreciated.

Sincerely,

Francis

mrskhris

Do you want to do this with page re-load or without?

bealot

hello mrskhris!

is it possible without reloading the page?
what ever is the easiest i'll be happy with any help

francis

mrskhris

Hi,

The easiest way will be WITH reloading the page.

Without:
1) If you have limited set of data, you can load it all at once during page creation. Then it's pretty much javascript - you'll have to re-create drop-down lists on-the-fly, which means you have to use onChange event for all dropdowns.

2) If your lists are long - very long, there is other way
a) create iframe on the page
b) user selects the entry from first list => content of iframe is changed by onChange event (e.g. iframe location is set to the script (php-script) that fetches the data for second drop-down. Once data is fetched, the javascript in main frame re-creates second dropdown.

I don't like either one of this ways 🙂

bealot

Is it possible to fetch the datas from a table (mysql) into the list/menu?

francis

bealot

do you know a website that has cetain tutorials with this kind of problem?

thanks for your help

francis