I have data on country, region, subregion codes and names in an xls file (see attachment)
What would be the best way to store this data in a database (mysql)?
I'm also going to be adding a further column with cities.
e.g. should the countries, regions, subregions, cities each have their own table and be linked through a foreign key?
or should all the data be in the same table?
Does it make sense to hold this data in the DB in the first place as opposed to in arrays in php files?
I'll be doing up to 20 lookups on a single page where i will have, for example, GB-BNE ... and I'll need to fetch that it's Barnet in England in United Kingdom so I'm looking for an efficient way to do this.