Re: SQL dumps for PHP forms of commonly used data

Oops - list is a two column list as published. You just cut and paste it, the nadd quotes, whatever. Probably best to make it a two-dimensional array and then use a PHP script to upload it. (Alternately, stick it in a function and call it from there as a genral purpose "country-picker" Miles Miles Thompson wrote: > Here ya go ... > # Country table contains list of countries from ISO according to ISO 3166 > Maintenance Agency. The list can be downloaded from > > http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1/db_en.html and > consists > of two columns, the country and the two letter code. Order of fields matches > the arrangement of the list. > drop table if exists country_code ; > create table country_code ( > cCountry varchar(20) , > cCountryCode char(2) primary key ) ; > > Miles > > Kevin Ferron wrote: > > > can anyone think of where a good resource for finding SQL dumps of commonly > > used information could be? > > > > ie. countries/country codes/zip codes/area codes > > > > thanks > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net