TomatoCart

Hi,

I find the UK zones a little random.

Although Counties are no longer used officially in addresses; it's still in common practice. The zone list included is a little incomplete and randomly uses either towns or counties. I've used the following SQL list on projects and found it quite useful. download page from echo computers

Could an update be produced or perhaps you could give me a little help pointing me in the right direction to amend the table personally.

James

download SQL

Taking a look at the table is it necessary for tomato cart to have the three letter zone code? If I enter the correct number of towns the generation of such a list would be time consuming and possibly too short for the data set.

Could I get away with setting it to a null value or possible an new numeric id?

James

To make counties I've added the attached counties list to zones. I'll report back if any difficulties. I did need to remove the preloaded data that contained a really strange mixture of towns and counties.

James

UKcounties.txt