Dependent List Boxes on Form

[Anon]

I was wondering if someone could help me a little further on this. I have a form with "World Location", Country, State, and City. I want the user to be able to select a region of the world(i.e North America) then based upon the region they select I want to populate the next list box(country) with the appropriate country values(i.e. United States,Canada,Mexico). Then based upon the country have the user pick a state (if they chose United States) and then choose a city within that country. The city list box would of course be populated with only cities that belong in that country...not all cities in the database. I realize that javascript is the best way to do this. The difficulty I see is that these values are not static and are coming from the mysql database. I figure that I need to somehow pass the result of the first list box into a where clause so it will limit the results of the country box etc...
I guess I'm just not certain of the placement of the calls to the database and how to reference the variables in the where clause. If anyone has an example of dependent list boxes coming from a mysql database that would be real helpful. I'm a newbie to the Javascript and HTML...more of an ERP PeopleSoft guy. Thanks.

[[deleted]]

There are a few examples of that functionality on javascript.internet.com ("The" resource for javascripts)

The data is stored in arrays, "all" you have to do is generate the content for those arrays, which is simply a copy of table-content, but seperated by whatever references them.
So you'r have an array of countries, then for every country you'd have one array for states, for each state you'd have arrays for cities.

Look at the javascript examples and you'll soon get the idea.