ASP-Drop down box

[hemmca]

I am using ASP and MS access

I have stored the names of the cities of 3 countries in my database.

Eg:-USA:-Newyork,Losangeles,washington
England :-London, Lords
India :-NewDelhi,Bombay,Calcutta

I will display name of all countries(USA,England,India) in first drop down box.

I want ASP code for the following.

My question is " I have 2 drop down boxes called country and city.
So when I select USA in firstdrop down box, then all the cities of
USA saved in my database should be displayed in second drop down box.
Similarly when I select England."

I want ASP code for the above.

please reply to this.

________________________________________________________________

Can you give me the code for
"Displaying all the User name of that Particular City"
________________________________________________________________

[buntine]

It depends on the way your database is designed. Do you have two tables; one named countries and one named cities?

Regards.

[wmif]

if you want code just written for you, check out guru.com and pay someone. otherwise post up some code you have started with to get help on.

[phpnovice]

My question is " I have 2 drop down boxes called country and city.
So when I select USA in firstdrop down box, then all the cities of
USA saved in my database should be displayed in second drop down box.
Similarly when I select England."

You cannot accomplish this in ASP unless you're planning to submit the country name to the server so that ASP can build the content of the second dropdown box and send it back to the client. If you wanted the second dropdown box to be populated automatically on the client side, then you really need to ask this question in the JavaScript forum. All ASP can do, in that case, is provide the data in JavaScript data arrays and, then, let JavaScript pick and chose what it wants to display when the time comes.