dynamic menu from the database
Posted: Thu Jan 03, 2013 1:30 am
let's say that i have a table with all the citys and states like
id zip_code city county state_name state_prefix area_code time_zone lat lon
40001 0 All All A N/A N/A 0 0
15366 35077 Hanceville Cullman Alabama AL 256 Central 34.0643 -86.7585
15351 35055 Cullman Cullman Alabama AL 256 Central 34.174 -86.8437
15350 35054 Cropwell Saint Clair Alabama AL 205 Central 33.507 -86.2945
15349 35053 Crane Hill Cullman Alabama AL 256 Central 34.0716 -87.0597
15348 35052 Cook Springs Saint Clair Alabama AL 205 Central 33.5911 -86.3912
15347 35051 Columbiana Shelby Alabama AL 205 Central 33.1823 -86.605
15346 35049 Cleveland Blount Alabama AL 205 Central 33.9692 -86.5984
15345 35048 Clay Jefferson Alabama AL 205 Central 33.7357 -86.5702
15344 35046 Clanton Chilton Alabama AL 205 Central 32.8394 -86.6235
15343 35045 Clanton Chilton Alabama AL 205 Central 32.8392 -86.6309
15342 35044 Childersburg Talladega Alabama AL 256 Central 33.2766 -86.3523
how can i make 2 combo box for states and cities changing the city value according to the state combo box value
id zip_code city county state_name state_prefix area_code time_zone lat lon
40001 0 All All A N/A N/A 0 0
15366 35077 Hanceville Cullman Alabama AL 256 Central 34.0643 -86.7585
15351 35055 Cullman Cullman Alabama AL 256 Central 34.174 -86.8437
15350 35054 Cropwell Saint Clair Alabama AL 205 Central 33.507 -86.2945
15349 35053 Crane Hill Cullman Alabama AL 256 Central 34.0716 -87.0597
15348 35052 Cook Springs Saint Clair Alabama AL 205 Central 33.5911 -86.3912
15347 35051 Columbiana Shelby Alabama AL 205 Central 33.1823 -86.605
15346 35049 Cleveland Blount Alabama AL 205 Central 33.9692 -86.5984
15345 35048 Clay Jefferson Alabama AL 205 Central 33.7357 -86.5702
15344 35046 Clanton Chilton Alabama AL 205 Central 32.8394 -86.6235
15343 35045 Clanton Chilton Alabama AL 205 Central 32.8392 -86.6309
15342 35044 Childersburg Talladega Alabama AL 256 Central 33.2766 -86.3523
how can i make 2 combo box for states and cities changing the city value according to the state combo box value