US 50 States Dropdown Array for you - Happy Monday!

[eluser]shaffick[/eluser]
If anyone needs a list of countries (with country codes) and canadian and US states, lemme know, I'll share it. I'm just a little lazy to upload the file etc...and we dont have an attachment feature here

Just lemme know.

[eluser]steelaz[/eluser]
Sure we do, take a look at my post above

[eluser]drewbee[/eluser]
Country Codes... contains iso2, iso3, and number code. :grin:

Code:

CREATE TABLE IF NOT EXISTS `countries` (
  `iso` char(2) NOT NULL default '',
  `iso3` char(3) default NULL,
  `numcode` smallint(6) default NULL,
  `name` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`iso`),
  UNIQUE KEY `iso3` (`iso3`),
  UNIQUE KEY `numcode` (`numcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Grand total of 246 countries.

See attachment for inserts...

Enjoy Lovelies

[eluser]jackbenning[/eluser]
cherrio!
Thnx alot mate!

[eluser]Unknown[/eluser]
Hey guys,

PHP expert but fairly new to CodeIgniter. I know this an old post, but I'm having a heck of a time finding a suggestion on the "appropriate" place to put common arrays like this. Where did you end up placing this array? Within a helper function?

Thanks!
Jeremy

[eluser]InsiteFX[/eluser]
Usually in a helper file.