I have a list of places in the MySQL table with columns City_Name, Region_Name and Country_Name. I would like to pull the list of Cities based on the User Input. If there is only one city returned there is no problem in displaying the result. But if I have receive more than 1 result from the database (which is most likely, as there will be multiple cities in the world with the same name), then I need to have a way of showing the results by County and by Region as in the attached picture, so that the user could select the appropriate city.
Please see the picture you would better understand the problem.
I would appreciate it if somebody could provide some assistance. Thanks in advance.
Thanks for those who viewed this post. But as unfortunately nobody could provide their input, I would like to inform that I finally found excellent resource after googling several times. For those of you who would like to achieve what I was trying to achieve, visit: