Here is the list of US states which also include Canadian territories:
--
-- Table structure for table `state`
--
CREATE TABLE `state` (
`id` char(2) NOT NULL default '',
`name` varchar(30) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='list of states';
--
-- Dumping data for table `state`
--
INSERT INTO `state` VALUES ('AL', 'Alabama');
INSERT INTO `state` VALUES ('AK', 'Alaska');
INSERT INTO `state` VALUES ('AZ', 'Arizona');
INSERT INTO `state` VALUES ('AR', 'Arkansas');
INSERT INTO `state` VALUES ('CA', 'California');
INSERT INTO `state` VALUES ('CO', 'Colorado');
INSERT INTO `state` VALUES ('CT', 'Connecticut');
INSERT INTO `state` VALUES ('DC', 'District of Columbia');
INSERT INTO `state` VALUES ('DE', 'Delaware');
INSERT INTO `state` VALUES ('FL', 'Florida');
INSERT INTO `state` VALUES ('GA', 'Georgia');
INSERT INTO `state` VALUES ('HI', 'Hawaii');
INSERT INTO `state` VALUES ('ID', 'Idaho');
INSERT INTO `state` VALUES ('IL', 'Illinois');
INSERT INTO `state` VALUES ('IN', 'Indiana');
INSERT INTO `state` VALUES ('IA', 'Iowa');
INSERT INTO `state` VALUES ('KS', 'Kansas');
INSERT INTO `state` VALUES ('KY', 'Kentucky');
INSERT INTO `state` VALUES ('LA', 'Louisiana');
INSERT INTO `state` VALUES ('ME', 'Maine');
INSERT INTO `state` VALUES ('MD', 'Maryland');
INSERT INTO `state` VALUES ('MA', 'Massachusetts');
INSERT INTO `state` VALUES ('MI', 'Michigan');
INSERT INTO `state` VALUES ('MN', 'Minnesota');
INSERT INTO `state` VALUES ('MS', 'Mississippi');
INSERT INTO `state` VALUES ('MO', 'Missouri');
INSERT INTO `state` VALUES ('MT', 'Montana');
INSERT INTO `state` VALUES ('NE', 'Nebraska');
INSERT INTO `state` VALUES ('NV', 'Nevada');
INSERT INTO `state` VALUES ('NH', 'New Hampshire');
INSERT INTO `state` VALUES ('NJ', 'New Jersey');
INSERT INTO `state` VALUES ('NM', 'New Mexico');
INSERT INTO `state` VALUES ('NY', 'New York');
INSERT INTO `state` VALUES ('NC', 'North Carolina');
INSERT INTO `state` VALUES ('ND', 'North Dakota');
INSERT INTO `state` VALUES ('OH', 'Ohio');
INSERT INTO `state` VALUES ('OK', 'Oklahoma');
INSERT INTO `state` VALUES ('OR', 'Oregon');
INSERT INTO `state` VALUES ('PA', 'Pennsylvania');
INSERT INTO `state` VALUES ('PR', 'Puerto Rico');
INSERT INTO `state` VALUES ('RI', 'Rhode Island');
INSERT INTO `state` VALUES ('SC', 'South Carolina');
INSERT INTO `state` VALUES ('SD', 'South Dakota');
INSERT INTO `state` VALUES ('TN', 'Tennessee');
INSERT INTO `state` VALUES ('TX', 'Texas');
INSERT INTO `state` VALUES ('UT', 'Utah');
INSERT INTO `state` VALUES ('VT', 'Vermont');
INSERT INTO `state` VALUES ('VA', 'Virginia');
INSERT INTO `state` VALUES ('WA', 'Washington');
INSERT INTO `state` VALUES ('WV', 'West Virginia');
INSERT INTO `state` VALUES ('WI', 'Wisconsin');
INSERT INTO `state` VALUES ('WY', 'Wyoming');
INSERT INTO `state` VALUES ('AB', 'Alberta');
INSERT INTO `state` VALUES ('BC', 'British Columbia');
INSERT INTO `state` VALUES ('MB', 'Manitoba');
INSERT INTO `state` VALUES ('NB', 'New Brunswick');
INSERT INTO `state` VALUES ('NF', 'New Foundland');
INSERT INTO `state` VALUES ('NT', 'Nunavut');
INSERT INTO `state` VALUES ('NS', 'Nova Scotia');
INSERT INTO `state` VALUES ('ON', 'Ontario');
INSERT INTO `state` VALUES ('PE', 'Prince Edward Island');
INSERT INTO `state` VALUES ('QC', 'Quebec');
INSERT INTO `state` VALUES ('SK', 'Saskatchewan');
INSERT INTO `state` VALUES ('YT', 'Yukon');
INSERT INTO `state` VALUES ('ZZ', 'Other-Not Shown');
Simplerules wrote:
> This isn't specifically a Cake PHP problem, but does anybody know where
> I could find a list (preferably in SQL or PHP Array format) of all the
> states/countys in the world, for each country?
>
> I am creating a registration form and need have done the Country List,
> now I need the State list.
>
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---
