Hey,
I'm obviously new here. I some php knowledge, but not very much MySQL knowledge. Any help would be hugely appreciated. Perhaps even a trade of some graphic design work for some help making this come to reality.
I have a client who would like to use multiple dropdown list to narrow a selection of items to just a two or three. There are approximately 80 items right now, each with 5 different attribute.
We would like it so that each time you select from one dropdown an attribute the next dropdown dynamically changes and only shows attributes that relate to the remaining item. Example DropDown1 is the Continent (North America, Asia, etc), DropDown2 contains a list of the countries, DropDown3 contains a list of the providences/states/regions, DropDown4 contains a list of the cities. Once the all the preceding lists are chosen the user is then shown in plain text a list of the Stores in that city.
Thats not actually what we need narrowed down, so the database/tables wont actually be containing every city in the world—as I said only 80 items.
What do you think would be the best way to do this? Would using an xml or javascript table be easier than using mySQL and PHP? Do you know any tutorials on how this might be done. I've seen things that show 2 levels of dropdowns, but not 5 or 6 (as I need).
Please, please, please, please help.
