Countries and States database

Hello, is there a predefined list of all countries states out there?  I've been browsing the market for a while and haven't come across anything and I would love to have these already made...rather than hand enter them all.

Thanks

Chri

Heres Canada and The USA! I hand inserted these a while back and have them in my fix it files list on my website i try to put everything here and there just in case.

open phpmyadmin - backup DB and then hit SQL and paste this into the window and hit go...open admin and go to prevalues to see them and save them and the open fieldsbuilder to use the new !#states in your field

INSERT INTO `sys_pre_values` (`Key`, `Value`, `Order`, `LKey`, `LKey2`, `LKey3`, `Extra`, `Extra2`, `Extra3`) VALUES
('state', 'SC', 42, 'South Carolina', '', '', '', '', ''),
('state', 'RI', 41, 'Rhode Island', '', '', '', '', ''),
('state', 'PA', 40, 'Pennsylvania', '', '', '', '', ''),
('state', 'OR', 39, 'Oregon', '', '', '', '', ''),
('state', 'OK', 38, 'Oklahoma', '', '', '', '', ''),
('state', 'OH', 37, 'Ohio', '', '', '', '', ''),
('state', 'ND', 36, 'North Dakota', '', '', '', '', ''),
('state', 'NC', 35, 'North Carolina', '', '', '', '', ''),
('state', 'NY', 34, 'New York', '', '', '', '', ''),
('state', 'NM', 33, 'New Mexico', '', '', '', '', ''),
('state', 'NJ', 32, 'New Jersey', '', '', '', '', ''),
('state', 'NH', 31, 'New Hampshire', '', '', '', '', ''),
('state', 'NV', 30, 'Nevada', '', '', '', '', ''),
('state', 'NE', 29, 'Nebraska', '', '', '', '', ''),
('state', 'MT', 28, 'Montana', '', '', '', '', ''),
('state', 'MO', 27, 'Missouri', '', '', '', '', ''),
('state', 'MS', 26, 'Mississippi', '', '', '', '', ''),
('state', 'MN', 25, 'Minnesota', '', '', '', '', ''),
('state', 'MI', 24, 'Michigan', '', '', '', '', ''),
('state', 'MA', 23, 'Massachusetts', '', '', '', '', ''),
('state', 'MD', 22, 'Maryland', '', '', '', '', ''),
('state', 'ME', 21, 'Maine', '', '', '', '', ''),
('state', 'LA', 20, 'Louisiana', '', '', '', '', ''),
('state', 'KY', 19, 'Kentucky', '', '', '', '', ''),
('state', 'KS', 18, 'Kansas', '', '', '', '', ''),
('state', 'IA', 17, 'Iowa', '', '', '', '', ''),
('state', 'IN', 16, 'Indiana', '', '', '', '', ''),
('state', 'IL', 15, 'Illinois', '', '', '', '', ''),
('state', 'IA', 14, 'Iowa', '', '', '', '', ''),
('state', 'IN', 13, 'Indiana', '', '', '', '', ''),
('state', 'IL', 12, 'Illinois', '', '', '', '', ''),
('state', 'ID', 11, 'Idaho', '', '', '', '', ''),
('state', 'HI', 10, 'Hawaii', '', '', '', '', ''),
('state', 'GA', 9, 'Georgia', '', '', '', '', ''),
('state', 'FL', 8, 'Florida', '', '', '', '', ''),
('state', 'DE', 7, 'Delaware', '', '', '', '', ''),
('state', 'CT', 6, 'Connecticut', '', '', '', '', ''),
('state', 'CO', 5, 'Colorado', '', '', '', '', ''),
('state', 'CA', 4, 'California', '', '', '', '', ''),
('state', 'AR', 3, 'Arkansas', '', '', '', '', ''),
('state', 'AZ', 2, 'Arizona', '', '', '', '', ''),
('state', 'AK', 1, 'Alaska', '', '', '', '', ''),
('state', 'AL', 0, 'Alabama', '', '', '', '', ''),
('state', 'SD', 43, 'South Dakota', '', '', '', '', ''),
('state', 'TN', 44, 'Tennessee', '', '', '', '', ''),
('state', 'TX', 45, 'Texas', '', '', '', '', ''),
('state', 'UT', 46, 'Utah', '', '', '', '', ''),
('state', 'VT', 47, 'Vermont', '', '', '', '', ''),
('state', 'VA', 48, 'Virginia', '', '', '', '', ''),
('state', 'WA', 49, 'Washington', '', '', '', '', ''),
('state', 'WV', 50, 'West Virginia', '', '', '', '', ''),
('state', 'WI', 51, 'Wisconsin', '', '', '', '', ''),
('state', 'WY', 52, 'Wyoming', '', '', '', '', ''),
('state', 'AB', 53, 'Alberta', '', '', '', '', ''),
('state', 'BC', 54, 'British Columbia', '', '', '', '', ''),
('state', 'MA', 55, 'Manitoba', '', '', '', '', ''),
('state', 'NB', 56, 'New Brunswick', '', '', '', '', ''),
('state', 'NL', 57, 'Newfoundland and Labrador', '', '', '', '', ''),
('state', 'NS', 58, 'Nova Scotia', '', '', '', '', ''),
('state', 'ON', 59, 'Ontario', '', '', '', '', ''),
('state', 'PE', 60, 'Prince Edward Island', '', '', '', '', ''),
('state', 'QU', 61, 'Quebec', '', '', '', '', ''),
('state', 'SK', 62, 'Saskatchewan', '', '', '', '', ''),
('state', 'NW', 63, 'Northwest Territories', '', '', '', '', '');

very nice mrp, i think i will have to give this one a go. this should be set on a sticky note or posted in tricks and tips mrp.

Regards,

DosDawg

For Australia you can download a list of postcodes and towns. The data needs to be converted to insert it into the database as above (or a script written).

I've seen similar lists for sale for lotsa $$$$'s

This one's free :)

Here's the download link for those interested.

http://auspost.com.au/apps/postcode.html

/DM