Automatic Data population from DB in Dropdowns

Hi,

I am having 2 dropdowns on my page. The values in both the drop downs have to be populated through

DataBase.

Problem : I dont know how to populate the second Dropdown automatically if items in first dropdown

changes.

First DropDown : City names are getting populated as per user's country.

Second Dropdown : Market names to be populated here when a city name is selected in first drop down.

Please show me some way to populate the Market names as per selected city name in first drop down.

I understand that I will have to use Java script. And I think I will have to use OnChange event. But after giving it a try, I could not do it.
( I am not Using AJAX).

Many thanks for your help.

Regds
Vivek Jain

re: Automatic Data population from DB in Dropdowns

On another forum I have suggested you ask your javascript questions on the javascript forum, not in the server-side/CGI forum. Even though you are using perl and a cgi script this is still a javscripting question. You will just include the javascript in the output of the cgi script, just like you do with html output.