spires Posted June 30, 2011 Share Posted June 30, 2011 Hi I'm trying to build a register page for an international website. I currently have the IOS Code E.G: AFGHANISTAN AF AFG But how do I go about getting all of the sub Derivatives ? E.G UK - Essex, Harlow, London, Manchester etc Thanks Quote Link to comment https://forums.phpfreaks.com/topic/240825-ios-list-of-countries-but-how-do-i-find-the-counties/ Share on other sites More sharing options...
xyph Posted June 30, 2011 Share Posted June 30, 2011 Have a database with a parent->child relationship? Or are you asking where this information can be found? Quote Link to comment https://forums.phpfreaks.com/topic/240825-ios-list-of-countries-but-how-do-i-find-the-counties/#findComment-1236941 Share on other sites More sharing options...
spires Posted June 30, 2011 Author Share Posted June 30, 2011 yeah, Where I can find the information. I've got the countries, but thats it so far. Thanks for your help Quote Link to comment https://forums.phpfreaks.com/topic/240825-ios-list-of-countries-but-how-do-i-find-the-counties/#findComment-1236943 Share on other sites More sharing options...
xyph Posted June 30, 2011 Share Posted June 30, 2011 This isn't a PHP question. Try google, I hear they've got most of the internet indexed. Quote Link to comment https://forums.phpfreaks.com/topic/240825-ios-list-of-countries-but-how-do-i-find-the-counties/#findComment-1236945 Share on other sites More sharing options...
spires Posted June 30, 2011 Author Share Posted June 30, 2011 lol, Sorry it is a PHP question. Basically, yes I don't know where to get the info, which I'll be able to find. But also don't know who to structure the DB. What I'm after doing to just like on the dating sites. Where you can select an area, e.g London, then view profiles with a selected mile radious. e.g 10 miles. I'm assuming it is to do with the IOS. Before I had: Country - id - name Country - id - countryID - name Area - id - countryID - countyID Areacode - id - code But this is not going to allow me to do what I need. Any idea, ho I should be structuring it? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/240825-ios-list-of-countries-but-how-do-i-find-the-counties/#findComment-1236949 Share on other sites More sharing options...
xyph Posted June 30, 2011 Share Posted June 30, 2011 Doing this globally is going to be VERY difficult. You're going to have to have a database filled with positional data of EVERY area code for EVERY county for EVERY country you want to support. Once you have that, it's a matter of a few SQL queries You could also avoid this by implementing the Google Maps API somehow. From what I understand Google Maps can convert an address to a latitude/longitude pair. http://code.google.com/apis/maps/documentation/geocoding/ Quote Link to comment https://forums.phpfreaks.com/topic/240825-ios-list-of-countries-but-how-do-i-find-the-counties/#findComment-1237018 Share on other sites More sharing options...
spires Posted June 30, 2011 Author Share Posted June 30, 2011 Hi, Thanks thats a big help Much appreciated. I'll look into how Google works. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/240825-ios-list-of-countries-but-how-do-i-find-the-counties/#findComment-1237025 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.