I am making a restauant review web page and I want users to be able to be able to select a country then a region and then finaly a town to get information about. It's going to be programed in PHP & MySQL, I know how the code will work but I have no idea how to get a complete list of all the towns / villages in the world and which region / country they are in! Any ideas?
2006-07-09 11:02:23 · 2 answers · asked by alexjcharlton 3 in Computers & Internet ➔ Internet
I am looking for an source of precompiled information, idealy in DB form, which doesnt require me to manualy enter the details of many millions of towns.
2006-07-09 11:18:06 · update #1
There is a type of book (remember book?) available at bookshops and libraries (that's where you can read books for free). This book is clled an ATLAS. Try it.
2006-07-09 11:07:18 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Even the most comprehensive atlas in the world could miss small towns.
Your best bet would be to list major cities and towns, and give the option of other and allow the person to type in the name of the town.
On top of this, you could then store those "other" entries so that they show up in the original list for other people to select. That way, you have the users of your site also building the list of towns.
2006-07-09 11:15:12 · answer #2 · answered by Shaun B 2 · 0⤊ 0⤋