Hi all,

With reference to the mzmt module, below is from Jason Guerney's royal mail 'royalmail_geozone.sql' file.

('', 'Shp: Royal Mail UK', 'Royal Mail: UK Only', NULL, now());

INSERT INTO `zones_to_geo_zones` VALUES
('', 222, '', last_insert_id(), NULL, now()),
('', 241, '', last_insert_id(), NULL, now()),
('', 242, '', last_insert_id(), NULL, now()),
('', 243, '', last_insert_id(), NULL, now()),
('', 244, '', last_insert_id(), NULL, now()),
('', 245, '', last_insert_id(), NULL, now()),
('', 246, '', last_insert_id(), NULL, now());

Now, I am no programmer, but from looking at the code above, I would say that its for UK deliveries, and the 222, 241, 242 etc.... numbers are the country ID's for countries included in this shipping zone, I am needing to modifiy Jason's sql for my own needs, so that I am shipping to England/Scottish (lowlands)/Wales, N.Ireland, RO Ireland, France, USA, Canada and a number of other countries in Europe - unfortunately, for the life of me, I cannot find an exhaustive listed of what country id number ref to which country.

ie: 222 = England
241 = N.Ireland etc...

The above are guesses, and are most probably wrong... but I hope you understand what I'm after.

Many Thanks, Vaughn, S.Wales, UK.