IOS List of Countries - But How Do I Find The Counties?

[spires]

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

 

[xyph]

Have a database with a parent->child relationship?

 

Or are you asking where this information can be found?

[spires]

yeah, Where I can find the information.

 

I've got the countries, but thats it so far.

 

 

Thanks for your help

[xyph]

This isn't a PHP question.

 

Try google, I hear they've got most of the internet indexed.

[spires]

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

[xyph]

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/

[spires]

Hi, Thanks thats a big help

Much appreciated.

I'll look into how Google works.

 

Thanks