Entering country/region in an option field

[Steve Leader]

Hi everyone,
I am developing a form page where customers enter their details (name, country etc). On some sites the form gives the options for an a-z of countries. How do I do this please? Surely they are not entered by hand.

[tmmoose]

<select name="country1" size=1>
<option selected>Canada</option>
<OPTION VALUE="Afghanistan" >Afghanistan
<OPTION VALUE="Albania" >Albania
<OPTION VALUE="Algeria" >Algeria
<OPTION VALUE="American Samoa" >American Samoa
<OPTION VALUE="Andorra" >Andorra
<OPTION VALUE="Angola" >Angola
<OPTION VALUE="Anguilla" >Anguilla
<OPTION VALUE="Antarctica" >Antarctica
<OPTION VALUE="Antigua and Barbuda" >Antigua and Barbuda
<OPTION VALUE="Argentina" >Argentina
<OPTION VALUE="Armenia" >Armenia
<OPTION VALUE="Aruba" >Aruba
<OPTION VALUE="Australia" >Australia
<OPTION VALUE="Austria" >Austria
<OPTION VALUE="Azerbaidjan" >Azerbaidjan
<OPTION VALUE="Bahamas" >Bahamas
<OPTION VALUE="Bahrain" >Bahrain
<OPTION VALUE="Bangladesh" >Bangladesh
<OPTION VALUE="Barbados" >Barbados
<OPTION VALUE="Belarus" >Belarus
<OPTION VALUE="Belgium" >Belgium
<OPTION VALUE="Belize" >Belize
<OPTION VALUE="Benin" >Benin
<OPTION VALUE="Bermuda" >Bermuda
<OPTION VALUE="Bolivia" >Bolivia
<OPTION VALUE="Bosnia-Herzegovina" >Bosnia-Herzegovina
<OPTION VALUE="Botswana" >Botswana
<OPTION VALUE="Bouvet Island" >Bouvet Island
<OPTION VALUE="Brazil" >Brazil
<OPTION VALUE="British Indian Ocean Territory" >British Indian Ocean Territory
<OPTION VALUE="Brunei Darussalam" >Brunei Darussalam
<OPTION VALUE="Bulgaria" >Bulgaria
<OPTION VALUE="Burkina Faso" >Burkina Faso
<OPTION VALUE="Burundi" >Burundi
<OPTION VALUE="Buthan" >Buthan
<OPTION VALUE="Cambodia" >Cambodia
<OPTION VALUE="Cameroon" >Cameroon
<OPTION VALUE="Cape Verde" >Cape Verde
<OPTION VALUE="Cayman Islands" >Cayman Islands
<OPTION VALUE="Central African Republic" >Central African Republic
<OPTION VALUE="Chad" >Chad
<OPTION VALUE="Chile" >Chile
<OPTION VALUE="China" >China
<OPTION VALUE="Christmas Island" >Christmas Island
<OPTION VALUE="Cocos Islands" >Cocos Islands
<OPTION VALUE="Colombia" >Colombia
<OPTION VALUE="Comoros" >Comoros
<OPTION VALUE="Congo" >Congo
<OPTION VALUE="Cook Islands" >Cook Islands
<OPTION VALUE="Costa Rica" >Costa Rica
<OPTION VALUE="Croatia" >Croatia
<OPTION VALUE="Cuba" >Cuba
<OPTION VALUE="Cyprus" >Cyprus
<OPTION VALUE="Czech Republic" >Czech Republic
<OPTION VALUE="Czechoslovakia" >Czechoslovakia
<OPTION VALUE="Denmark" >Denmark
<OPTION VALUE="Djibouti" >Djibouti
<OPTION VALUE="Dominica" >Dominica
<OPTION VALUE="Dominican Republic" >Dominican Republic
<OPTION VALUE="East Timor" >East Timor
<OPTION VALUE="Ecuador" >Ecuador
<OPTION VALUE="Egypt" >Egypt
<OPTION VALUE="El Salvador" >El Salvador
<OPTION VALUE="Equatorial Guinea" >Equatorial Guinea
<OPTION VALUE="Estonia" >Estonia
<OPTION VALUE="Ethiopia" >Ethiopia
<OPTION VALUE="Falkland Islands" >Falkland Islands
<OPTION VALUE="Faroe Islands" >Faroe Islands
<OPTION VALUE="Fiji" >Fiji
<OPTION VALUE="Finland" >Finland
<OPTION VALUE="France" >France
<OPTION VALUE="France European Territory" >France European Territory
<OPTION VALUE="French Guadeloupe" >French Guadeloupe
<OPTION VALUE="French Guyana" >French Guyana
<OPTION VALUE="French Martinique" >French Martinique
<OPTION VALUE="French Polynesia" >French Polynesia
<OPTION VALUE="French Southern Territory" >French Southern Territory
<OPTION VALUE="Gabon" >Gabon
<OPTION VALUE="Gambia" >Gambia
<OPTION VALUE="Georgia" >Georgia
<OPTION VALUE="Germany" >Germany
<OPTION VALUE="Ghana" >Ghana
<OPTION VALUE="Gibraltar" >Gibraltar
<OPTION VALUE="Great Britain" >Great Britain
<OPTION VALUE="Greece" >Greece
<OPTION VALUE="Greenland" >Greenland
<OPTION VALUE="Grenada" >Grenada
<OPTION VALUE="Guam" >Guam
<OPTION VALUE="Guatemala" >Guatemala
<OPTION VALUE="Guernsey"> Guernsey
<OPTION VALUE="Guinea" >Guinea
<OPTION VALUE="Guinea Bissau" >Guinea Bissau
<OPTION VALUE="Guyana" >Guyana
<OPTION VALUE="Haiti" >Haiti
<OPTION VALUE="Heard and McDonald Islands" >Heard and McDonald Islands
<OPTION VALUE="Honduras" >Honduras
<OPTION VALUE="Hong Kong" >Hong Kong
<OPTION VALUE="Hungary" >Hungary
<OPTION VALUE="Iceland" >Iceland
<OPTION VALUE="India" >India
<OPTION VALUE="Indonesia" >Indonesia
<OPTION VALUE="Iran" >Iran
<OPTION VALUE="Iraq" >Iraq
<OPTION VALUE="Ireland" >Ireland
<OPTION VALUE="Israel" >Israel
<OPTION VALUE="Italy" >Italy
<OPTION VALUE="Ivory Coast" >Ivory Coast
<OPTION VALUE="Jamaica" >Jamaica
<OPTION VALUE="Japan" >Japan
<OPTION VALUE="Jersey" >Jersey
<OPTION VALUE="Jordan" >Jordan
<OPTION VALUE="Kazachstan" >Kazachstan
<OPTION VALUE="Kenya" >Kenya
<OPTION VALUE="Kirgistan" >Kirgistan
<OPTION VALUE="Kiribati" >Kiribati
<OPTION VALUE="Kuwait" >Kuwait
<OPTION VALUE="Laos" >Laos
<OPTION VALUE="Latvia" >Latvia
<OPTION VALUE="Lebanon" >Lebanon
<OPTION VALUE="Lesotho" >Lesotho
<OPTION VALUE="Liberia" >Liberia
<OPTION VALUE="Libya" >Libya
<OPTION VALUE="Liechtenstein" >Liechtenstein
<OPTION VALUE="Lithuania" >Lithuania
<OPTION VALUE="Luxembourg" >Luxembourg
<OPTION VALUE="Macau" >Macau
<OPTION VALUE="Madagascar" >Madagascar
<OPTION VALUE="Malawi" >Malawi
<OPTION VALUE="Malaysia" >Malaysia
<OPTION VALUE="Maldives" >Maldives
<OPTION VALUE="Mali" >Mali
<OPTION VALUE="Malta" >Malta
<OPTION VALUE="Marshall Islands" >Marshall Islands
<OPTION VALUE="Mauritania" >Mauritania
<OPTION VALUE="Mauritius" >Mauritius
<OPTION VALUE="Mexico" >Mexico
<OPTION VALUE="Micronesia" >Micronesia
<OPTION VALUE="Moldavia" >Moldavia
<OPTION VALUE="Monaco" >Monaco
<OPTION VALUE="Mongolia" >Mongolia
<OPTION VALUE="Montserrat" >Montserrat
<OPTION VALUE="Morocco" >Morocco
<OPTION VALUE="Mozambique" >Mozambique
<OPTION VALUE="Myanmar" >Myanmar
<OPTION VALUE="Namibia" >Namibia
<OPTION VALUE="Nauru" >Nauru
<OPTION VALUE="Nepal" >Nepal
<OPTION VALUE="Netherland Antilles" >Netherland Antilles
<OPTION VALUE="Netherlands" >Netherlands
<OPTION VALUE="Neutral Zone" >Neutral Zone
<OPTION VALUE="New Caledonia" >New Caledonia
<OPTION VALUE="New Zealand" >New Zealand
<OPTION VALUE="Nicaragua" >Nicaragua
<OPTION VALUE="Niger" >Niger
<OPTION VALUE="Nigeria" >Nigeria
<OPTION VALUE="Niue" >Niue
<OPTION VALUE="Norfolk Island" >Norfolk Island
<OPTION VALUE="North Korea" >North Korea
<OPTION VALUE="Northern Mariana Islands" >Northern Mariana Islands
<OPTION VALUE="Norway" >Norway
<OPTION VALUE="Oman" >Oman
<OPTION VALUE="Pakistan" >Pakistan
<OPTION VALUE="Palau" >Palau
<OPTION VALUE="Panama" >Panama
<OPTION VALUE="Papua New Guinea" >Papua New Guinea
<OPTION VALUE="Paraguay" >Paraguay
<OPTION VALUE="Peru" >Peru
<OPTION VALUE="Philippines" >Philippines
<OPTION VALUE="Pitcairn" >Pitcairn
<OPTION VALUE="Poland" >Poland
<OPTION VALUE="Portugal" >Portugal
<OPTION VALUE="Puerto Rico" >Puerto Rico
<OPTION VALUE="Qatar" >Qatar
<OPTION VALUE="Reunion" >Reunion
<OPTION VALUE="Romania" >Romania
<OPTION VALUE="Russian Federation" >Russian Federation
<OPTION VALUE="Rwanda" >Rwanda
<OPTION VALUE="Saint Helena" >Saint Helena
<OPTION VALUE="Saint Kitts Nevis Anguilla" >Saint Kitts Nevis Anguilla
<OPTION VALUE="Saint Lucia" >Saint Lucia
<OPTION VALUE="Saint Pierre and Miquelon" >Saint Pierre and Miquelon
<OPTION VALUE="Saint Tome and Principe" >Saint Tome and Principe
<OPTION VALUE="Saint Vincent and Grenadines" >Saint Vincent and Grenadines
<OPTION VALUE="Samoa" >Samoa
<OPTION VALUE="San Marino" >San Marino
<OPTION VALUE="Saudi Arabia" >Saudi Arabia
<OPTION VALUE="Senegal" >Senegal
<OPTION VALUE="Seychelles" >Seychelles
<OPTION VALUE="Sierra Leone" >Sierra Leone
<OPTION VALUE="Singapore" >Singapore
<OPTION VALUE="Slovak Republic" >Slovak Republic
<OPTION VALUE="Slovenia" >Slovenia
<OPTION VALUE="Solomon Islands" >Solomon Islands
<OPTION VALUE="Somalia" >Somalia
<OPTION VALUE="South Africa" >South Africa
<OPTION VALUE="South Korea" >South Korea
<OPTION VALUE="Soviet Union" >Soviet Union
<OPTION VALUE="Spain" >Spain
<OPTION VALUE="Sri Lanka" >Sri Lanka
<OPTION VALUE="Sudan" >Sudan
<OPTION VALUE="Suriname" >Suriname
<OPTION VALUE="Svalbard and Jan Mayen Islands" >Svalbard and Jan Mayen islands
<OPTION VALUE="Swaziland" >Swaziland
<OPTION VALUE="Sweden" >Sweden
<OPTION VALUE="Switzerland" >Switzerland
<OPTION VALUE="Syria" >Syria
<OPTION VALUE="Tadjikistan" >Tadjikistan
<OPTION VALUE="Taiwan" >Taiwan
<OPTION VALUE="Tanzania" >Tanzania
<OPTION VALUE="Thailand" >Thailand
<OPTION VALUE="Togo" >Togo
<OPTION VALUE="Tokelau" >Tokelau
<OPTION VALUE="Tonga" >Tonga
<OPTION VALUE="Trinidad and Tobago" >Trinidad and Tobago
<OPTION VALUE="Tunisia" >Tunisia
<OPTION VALUE="Turkey" >Turkey
<OPTION VALUE="Turkmenistan" >Turkmenistan
<OPTION VALUE="Turks and Caicos Islands" >Turks and Caicos Islands
<OPTION VALUE="Tuvalu" >Tuvalu
<OPTION VALUE="US Minor Outlying Islands" >US Minor Outlying Islands
<OPTION VALUE="Uganda" >Uganda
<OPTION VALUE="Ukraine" >Ukraine
<OPTION VALUE="United Arab Emirates" >United Arab Emirates
<OPTION VALUE="United Kingdom" >United Kingdom
<OPTION VALUE="United States" >United States
<OPTION VALUE="Uruguay" >Uruguay
<OPTION VALUE="Uzbekistan" >Uzbekistan
<OPTION VALUE="Vanuatu" >Vanuatu
<OPTION VALUE="Vatican City State" >Vatican City State
<OPTION VALUE="Venezuela" >Venezuela
<OPTION VALUE="Vietnam" >Vietnam
<OPTION VALUE="Virgin Islands British" >Virgin Islands British
<OPTION VALUE="Virgin Islands US" >Virgin Islands US
<OPTION VALUE="Wallis and Futuna Islands" >Wallis and Futuna Islands
<OPTION VALUE="Western Sahara" >Western Sahara
<OPTION VALUE="Yemen" >Yemen
<OPTION VALUE="Yugoslavia" >Yugoslavia
<OPTION VALUE="Zaire" >Zaire
<OPTION VALUE="Zambia" >Zambia
<OPTION VALUE="Zimbabwe" >Zimbabwe
</select>Country <br>

[DCElliott]

I see Moose has something to fit the bill. I had a similar problem where I had to make a pick list, except I programmatically generated the list code (and I hope Moose did as well).

Or is you wanted your data to be a bit more compact, I've attached a list of ISO 2-letter country codes and associated names. If you store the 2-letter names in your database and then relate to a lookup table your database can be much more compact.

The file is a zipped comma separated value database.

D

[Steve Leader]

Thanks TN and DC. I went whith TN's coding as it seems simpler. I am a firm believer in the KISS principle. God, I hope you cut and pasted it.

I have just done the same and it works exactly how I want. Thanks again.

[themadpoet]

The first method works very well I did this for the counties in England, Wales, Scotland and Ireland on my website. You can use it to go to parts of a page as well by linking to named sections of a page.

Put this in your options line

<option value="#Buckinghamshire">Buckinghamshire

and this in the place on the page
<A Name = "Buckinghamshire">Here's Buckinghamshire</a>

I saw a site where it showed regions within a country ina pick list once you'd picked it. Any ideas how you could do this easily?

Elliott xx