I have a many masters in my project of the basic one is country,state and city. i have added/inserted the records in mysql database but when i want to edit record how can i populate the state select tag when the country is selected from mysql database?
For example i have a record in city table as
╔════╦══════════════╦════
║ COUNTRY║ STATE║ CITY ║
╠========╬══════════════╬
║ INDIA ║ PUNJAB║ ABC ║
║ INDIA ║ J&K ║ PQR ║
║ USA ║ NJ ║ MNO ║
=========================
NOW when i go for edit operation for say suppose record 1 i.e INDIA-PUNJAB-ABC
I am able to select INDIA in Country select tag but i am not able to get only INDIA states and select ABC in select tag of state