I have 2 tables in MySQL.
First table has a name and a code. Second table as other names and a code for the code from the 1st table.
How can I select a value on an inputbox and according to that value, second inputbox will automatically shows only names that are from 1st inputbox?!
1st table -> Countries: USA, UK, Spain, Portugal
2nd table -> Cities: USA:New York; USA:Chicago; UK:London; SPAIN:Barcelona; SPAIN:MADRID; etc....