Hi every one
I have 3 drop down list in my page that fill data from Data base
first DDL show city name
second DDL show region
third DDL show shopping center
I want when user click DDL1 and select city in DDL2 just show region of that city and when user select region in DDL 3 just show shopping center of that region.
and this is my Table in DATABASE
Id
|
City
|
Region
|
shoppingcenter
|
1
|
Paris
|
1
|
Paris mall
|
2
|
Paris
|
1
|
Pris center
|
3
|
Paris
|
2
|
Paris mall1
|
4
|
Paris
|
3
|
Paris center2
|
5
|
India
|
5
|
India mall
|
6
|
India
|
5
|
India mall2
|
7
|
India
|
6
|
India mall3
|
how i can do it?
thanks