I'm designing a project now which will have cities saved into a DB. Say Auckland, Sydney, London (I would add more details than just a city name to the D😎. But what I want to happen is when a user loads a page there is a line between city pairs ie: Auckland and Sydney come up there would be a line between these...
Problems I have is there are a lot of cities in the world, would I have to add each one to the DB or could I use something like google maps and when a user adds say Sydney into a web form it finds sydney somehow....
am I making any sense???
Ideas/thoughts?