drop down dynamic change

[muzammil]

hi

i am using mysql as data base, i have three table category (courntry), subcategory (sates), subcategory2 (cities), i want to show respective satate when a country selected in drop down menu and similar in case of satate and city.

 

hope i get solutio for this.

 

[Barand]

if your table have a structure similar to this

[pre]

country            state              city

---------          ---------          ---------

id (int)  ---+    id (int)  ---+    id (int)

countryname  |    statename    |    cityname

              +---< countryID    +---< stateID

[/pre]

then the baaSelect link in my sig will help.

 

Otherwise, see the AJAX link