I have a form in PHP with a 3-letters country-code text field. When the third letter is entered i want the system to show the country-name and then the user can go on with the other form fields. Country-codes and names are in a mySQL database. If the country-code letters are GER (for Germany) i need a dropdownlist in addition to the country-code. This is for the state list.
Example Case 1:
User enters VIE then on the right of the text field appears Vietnam. Vietnam is set for the submit button and the user can go to next field.
Example Case 2:
User enters GER for Germany and the user will see Germany on the right of the text field. In addition a dropdown field will appear under the country-field which offers the users other options. Germany is devided in states and the user will be able to select a state from a list that comes from a mySQL database.