I need your suggestion for a programming issue using Yii framework where based on the country selected in a country-drop-down-list, I need to display the respective states in the states-drop-down-list.
Here in db schema, I had created a foreign key for the country id. I checked in database that each country table had its unique id, name and State table had entries of state name, country id and state id. please provide me your suggestion for getting the respective list of states depending upon the country id selected in a drop down list.