Auto "select country" dropdown

[JamesLean]

On many forms floating around the internet users are required to select which country they are from.

The list of countries is obviously quite long and from the looks of it is a "standard" list, ie names spelt correctly etc..

Does anyone know whether you can create this select list automatically? I can't believe you have to write all the country options manually!

--James

 

[mwolf00]

Find a site that lists them all, snag the HTML that creates them, copy the list, paste it into msWord (to hide the HTML option tags), copy the text list into excel, and import it into sql Server or whatever db you use....

Good luck

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook

 

[JamesLean]

Thanks Mike,
That kinda falls under "create the list manually" in my book! ;-)

I was thinking more along the lines of using something like an HTTP request object to grab them from somewhere? Maybe I'm clutching at straws though...?

--James

 

[theocraticmind]

They are usualy from a database. I have one here.

<select name=&quot;txtField1_1&quot; >

<option value=&quot;&quot; >---- SELECT ----</option>

<option value=&quot;1&quot; >Afghanistan</option>

<option value=&quot;2&quot; >Albania</option>

<option value=&quot;3&quot; >Algeria</option>

<option value=&quot;4&quot; >American Samoa</option>

<option value=&quot;5&quot; >Andorra</option>

<option value=&quot;6&quot; >Angola</option>

<option value=&quot;7&quot; >Anguilla</option>

<option value=&quot;8&quot; >Antarctica</option>

<option value=&quot;9&quot; >Antigua and Barbuda</option>

<option value=&quot;10&quot; >Argentina</option>

<option value=&quot;11&quot; >Armenia</option>

<option value=&quot;12&quot; >Aruba</option>

<option value=&quot;13&quot; >Australia</option>

<option value=&quot;14&quot; >Austria</option>

<option value=&quot;15&quot; >Azerbaijan</option>

<option value=&quot;16&quot; >Bahamas, The</option>

<option value=&quot;17&quot; >Bahrain</option>

<option value=&quot;18&quot; >Bangladesh</option>

<option value=&quot;19&quot; >Barbados</option>

<option value=&quot;20&quot; >Belarus</option>

<option value=&quot;21&quot; >Belgium</option>

<option value=&quot;22&quot; >Belize</option>

<option value=&quot;23&quot; >Benin</option>

<option value=&quot;24&quot; >Bermuda</option>

<option value=&quot;25&quot; >Bhutan</option>

<option value=&quot;26&quot; >Bolivia</option>

<option value=&quot;27&quot; >Bosnia</option>

<option value=&quot;28&quot; >Botswana</option>

<option value=&quot;29&quot; >Bouvet Island</option>

<option value=&quot;30&quot; >Brazil</option>

<option value=&quot;31&quot; >Brunei</option>

<option value=&quot;32&quot; >Bulgaria</option>

<option value=&quot;33&quot; >Burkina Faso</option>

<option value=&quot;34&quot; >Burundi</option>

<option value=&quot;35&quot; >Cambodia</option>

<option value=&quot;36&quot; >Cameroon</option>

<option value=&quot;37&quot; >Canada</option>

<option value=&quot;38&quot; >Cape Verde</option>

<option value=&quot;39&quot; >Cayman Islands</option>

<option value=&quot;40&quot; >Chad</option>

<option value=&quot;41&quot; >Chile</option>

<option value=&quot;42&quot; >China</option>

<option value=&quot;43&quot; >Christmas Island</option>

<option value=&quot;44&quot; >Cocos Islands</option>

<option value=&quot;45&quot; >Colombia</option>

<option value=&quot;46&quot; >Comoros</option>

<option value=&quot;47&quot; >Congo</option>

<option value=&quot;48&quot; >Cook Islands</option>

<option value=&quot;49&quot; >Costa Rica</option>

<option value=&quot;50&quot; >Cote D'Ivoire</option>

<option value=&quot;51&quot; >Croatia</option>

<option value=&quot;52&quot; >Cuba</option>

<option value=&quot;53&quot; >Cyprus</option>

<option value=&quot;54&quot; >Czech Republic</option>

<option value=&quot;55&quot; >Denmark</option>

<option value=&quot;56&quot; >Djibouti</option>

<option value=&quot;57&quot; >Dominica</option>

<option value=&quot;58&quot; >Dominican Republic</option>

<option value=&quot;59&quot; >East Timor</option>

<option value=&quot;60&quot; >Ecuador</option>

<option value=&quot;61&quot; >Egypt</option>

<option value=&quot;62&quot; >El Salvador</option>

<option value=&quot;63&quot; >Equatorial Guinea</option>

<option value=&quot;64&quot; >Eritrea</option>

<option value=&quot;65&quot; >Estonia</option>

<option value=&quot;66&quot; >Ethiopia</option>

<option value=&quot;67&quot; >Falkland Islands</option>

<option value=&quot;68&quot; >Faroe Islands</option>

<option value=&quot;69&quot; >Fiji Islands</option>

<option value=&quot;70&quot; >Finland</option>

<option value=&quot;71&quot; >France</option>

<option value=&quot;72&quot; >French Guiana</option>

<option value=&quot;73&quot; >French Polynesia</option>

<option value=&quot;74&quot; >Gabon</option>

<option value=&quot;75&quot; >Gambia</option>

<option value=&quot;76&quot; >Georgia</option>

<option value=&quot;77&quot; >Germany</option>

<option value=&quot;78&quot; >Ghana</option>

<option value=&quot;79&quot; >Gibraltar</option>

<option value=&quot;80&quot; >Greece</option>

<option value=&quot;81&quot; >Greenland</option>

<option value=&quot;82&quot; >Grenada</option>

<option value=&quot;83&quot; >Guadeloupe</option>

<option value=&quot;84&quot; >Guam</option>

<option value=&quot;85&quot; >Guatemala</option>

<option value=&quot;86&quot; >Guinea</option>

<option value=&quot;87&quot; >Guinea-Bissau</option>

<option value=&quot;88&quot; >Guyana</option>

<option value=&quot;89&quot; >Haiti</option>

<option value=&quot;90&quot; >Honduras</option>

<option value=&quot;91&quot; >Hong Kong S.A.R.</option>

<option value=&quot;92&quot; >Hungary</option>

<option value=&quot;93&quot; >Iceland</option>

<option value=&quot;94&quot; >India</option>

<option value=&quot;95&quot; >Indonesia</option>

<option value=&quot;96&quot; >Iran</option>

<option value=&quot;97&quot; >Iraq</option>

<option value=&quot;98&quot; >Ireland</option>

<option value=&quot;99&quot; >Israel</option>

<option value=&quot;100&quot; >Italy</option>

<option value=&quot;101&quot; >Jamaica</option>

<option value=&quot;102&quot; >Japan</option>

<option value=&quot;103&quot; >Jordan</option>

<option value=&quot;104&quot; >Kazakhstan</option>

<option value=&quot;105&quot; >Kenya</option>

<option value=&quot;106&quot; >Kiribati</option>

<option value=&quot;107&quot; >Korea</option>

<option value=&quot;108&quot; >Kuwait</option>

<option value=&quot;109&quot; >Kyrgyzstan</option>

<option value=&quot;110&quot; >Laos</option>

<option value=&quot;111&quot; >Latvia</option>

<option value=&quot;112&quot; >Lebanon</option>

<option value=&quot;113&quot; >Lesotho</option>

<option value=&quot;114&quot; >Liberia</option>

<option value=&quot;115&quot; >Libya</option>

<option value=&quot;116&quot; >Liechtenstein</option>

<option value=&quot;117&quot; >Lithuania</option>

<option value=&quot;118&quot; >Luxembourg</option>

<option value=&quot;119&quot; >Macau S.A.R.</option>

<option value=&quot;120&quot; >Macedonia</option>

<option value=&quot;121&quot; >Madagascar</option>

<option value=&quot;122&quot; >Malawi</option>

<option value=&quot;123&quot; >Malaysia</option>

<option value=&quot;124&quot; >Maldives</option>

<option value=&quot;125&quot; >Mali</option>

<option value=&quot;126&quot; >Malta</option>

<option value=&quot;127&quot; >Marshall Islands</option>

<option value=&quot;128&quot; >Martinique</option>

<option value=&quot;129&quot; >Mauritania</option>

<option value=&quot;130&quot; >Mauritius</option>

<option value=&quot;131&quot; >Mayotte</option>

<option value=&quot;132&quot; >Mexico</option>

<option value=&quot;133&quot; >Micronesia</option>

<option value=&quot;134&quot; >Moldova</option>

<option value=&quot;135&quot; >Monaco</option>

<option value=&quot;136&quot; >Mongolia</option>

<option value=&quot;137&quot; >Montserrat</option>

<option value=&quot;138&quot; >Morocco</option>

<option value=&quot;139&quot; >Mozambique</option>

<option value=&quot;140&quot; >Myanmar</option>

<option value=&quot;141&quot; >Namibia</option>

<option value=&quot;142&quot; >Nauru</option>

<option value=&quot;143&quot; >Nepal</option>

<option value=&quot;144&quot; >Netherlands</option>

<option value=&quot;145&quot; >New Caledonia</option>

<option value=&quot;146&quot; >New Zealand</option>

<option value=&quot;147&quot; >Nicaragua</option>

<option value=&quot;148&quot; >Niger</option>

<option value=&quot;149&quot; >Nigeria</option>

<option value=&quot;150&quot; >Niue</option>

<option value=&quot;151&quot; >Norfolk Island</option>

<option value=&quot;152&quot; >Northern Mariana Islands</option>

<option value=&quot;153&quot; >Norway</option>

<option value=&quot;154&quot; >Oman</option>

<option value=&quot;155&quot; >Pakistan</option>

<option value=&quot;156&quot; >Palau</option>

<option value=&quot;157&quot; >Panama</option>

<option value=&quot;158&quot; >Papua new Guinea</option>

<option value=&quot;159&quot; >Paraguay</option>

<option value=&quot;160&quot; >Peru</option>

<option value=&quot;161&quot; >Philippines</option>

<option value=&quot;162&quot; >Pitcairn Island</option>

<option value=&quot;163&quot; >Poland</option>

<option value=&quot;164&quot; >Portugal</option>

<option value=&quot;165&quot; >Puerto Rico</option>

<option value=&quot;166&quot; >Qatar</option>

<option value=&quot;167&quot; >Reunion</option>

<option value=&quot;168&quot; >Romania</option>

<option value=&quot;169&quot; >Russia</option>

<option value=&quot;170&quot; >Rwanda</option>

<option value=&quot;176&quot; >Samoa</option>

<option value=&quot;177&quot; >San Marino</option>

<option value=&quot;178&quot; >Sao Tome</option>

<option value=&quot;179&quot; >Saudi Arabia</option>

<option value=&quot;180&quot; >Senegal</option>

<option value=&quot;181&quot; >Seychelles</option>

<option value=&quot;182&quot; >Sierra Leone</option>

<option value=&quot;183&quot; >Singapore</option>

<option value=&quot;184&quot; >Slovakia</option>

<option value=&quot;185&quot; >Slovenia</option>

<option value=&quot;186&quot; >Solomon Islands</option>

<option value=&quot;187&quot; >Somalia</option>

<option value=&quot;188&quot; >South Africa</option>

<option value=&quot;189&quot; >South Georgia</option>

<option value=&quot;190&quot; >Spain</option>

<option value=&quot;191&quot; >Sri Lanka</option>

<option value=&quot;171&quot; >St. Helena</option>

<option value=&quot;172&quot; >St. Kitts and Nevis</option>

<option value=&quot;173&quot; >St. Lucia</option>

<option value=&quot;174&quot; >St. Pierre and Miquelon</option>

<option value=&quot;175&quot; >St. Vincent and The Grenadines</option>

<option value=&quot;192&quot; >Sudan</option>

<option value=&quot;193&quot; >Suriname</option>

<option value=&quot;194&quot; >Svalbard</option>

<option value=&quot;195&quot; >Swaziland</option>

<option value=&quot;196&quot; >Sweden</option>

<option value=&quot;197&quot; >Switzerland</option>

<option value=&quot;198&quot; >Syria</option>

<option value=&quot;199&quot; >Taiwan</option>

<option value=&quot;200&quot; >Tajikistan</option>

<option value=&quot;201&quot; >Tanzania</option>

<option value=&quot;202&quot; >Thailand</option>

<option value=&quot;203&quot; >Togo</option>

<option value=&quot;204&quot; >Tokelau</option>

<option value=&quot;205&quot; >Tonga</option>

<option value=&quot;206&quot; >Trinidad and Tobago</option>

<option value=&quot;207&quot; >Tunisia</option>

<option value=&quot;208&quot; >Turkey</option>

<option value=&quot;209&quot; >Turkmenistan</option>

<option value=&quot;210&quot; >Turks and Caicos Islands</option>

<option value=&quot;211&quot; >Tuvalu</option>

<option value=&quot;212&quot; >Uganda</option>

<option value=&quot;213&quot; >Ukraine</option>

<option value=&quot;214&quot; >United Arab Emirates</option>

<option value=&quot;215&quot; >United Kingdom</option>

<option value=&quot;216&quot; >United States</option>

<option value=&quot;217&quot; >Uruguay</option>

<option value=&quot;218&quot; >Uzbekistan</option>

<option value=&quot;219&quot; >Vanuatu</option>

<option value=&quot;220&quot; >Vatican City State</option>

<option value=&quot;221&quot; >Venezuela</option>

<option value=&quot;222&quot; >Vietnam</option>

<option value=&quot;223&quot; >Virgin Islands</option>

<option value=&quot;224&quot; >Wallis</option>

<option value=&quot;225&quot; >Yemen</option>

<option value=&quot;226&quot; >Yugoslavia</option>

<option value=&quot;227&quot; >Zambia</option>

<option value=&quot;228&quot; >Zimbabwe</option>

</select>



<select name=&quot;txtField1_2&quot; >

<option value=&quot;&quot; >---- SELECT ----</option>

<option value=&quot;242&quot; >Alabama</option>

<option value=&quot;243&quot; >Alaska</option>

<option value=&quot;244&quot; >Arizona</option>

<option value=&quot;245&quot; >Arkansas</option>

<option value=&quot;246&quot; >California</option>

<option value=&quot;247&quot; >Colorado</option>

<option value=&quot;248&quot; >Connecticut</option>

<option value=&quot;249&quot; >Delaware</option>

<option value=&quot;250&quot; >District of Columbia</option>

<option value=&quot;251&quot; >Florida</option>

<option value=&quot;252&quot; >Georgia</option>

<option value=&quot;253&quot; >Hawaii</option>

<option value=&quot;254&quot; >Idaho</option>

<option value=&quot;255&quot; >Illinois</option>

<option value=&quot;256&quot; >Indiana</option>

<option value=&quot;257&quot; >Iowa</option>

<option value=&quot;258&quot; >Kansas</option>

<option value=&quot;259&quot; >Kentucky</option>

<option value=&quot;260&quot; >Louisiana</option>

<option value=&quot;261&quot; >Maine</option>

<option value=&quot;262&quot; >Maryland</option>

<option value=&quot;263&quot; >Massachusetts</option>

<option value=&quot;264&quot; >Michigan</option>

<option value=&quot;265&quot; >Minnesota</option>

<option value=&quot;266&quot; >Mississippi</option>

<option value=&quot;267&quot; >Missouri</option>

<option value=&quot;268&quot; >Montana</option>

<option value=&quot;269&quot; >Nebraska</option>

<option value=&quot;270&quot; >Nevada</option>

<option value=&quot;271&quot; >New Hampshire</option>

<option value=&quot;272&quot; >New Jersey</option>

<option value=&quot;273&quot; >New Mexico</option>

<option value=&quot;274&quot; >New York</option>

<option value=&quot;275&quot; >North Carolina</option>

<option value=&quot;276&quot; >North Dakota</option>

<option value=&quot;277&quot; >Ohio</option>

<option value=&quot;278&quot; >Oklahoma</option>

<option value=&quot;279&quot; >Oregon</option>

<option value=&quot;280&quot; >Pennsylvania</option>

<option value=&quot;281&quot; >Rhode Island</option>

<option value=&quot;282&quot; >South Carolina</option>

<option value=&quot;283&quot; >South Dakota</option>

<option value=&quot;284&quot; >Tennessee</option>

<option value=&quot;285&quot; >Texas</option>

<option value=&quot;286&quot; >Utah</option>

<option value=&quot;287&quot; >Vermont</option>

<option value=&quot;288&quot; >Virginia</option>

<option value=&quot;289&quot; >Washington</option>

<option value=&quot;290&quot; >West Virginia</option>

<option value=&quot;291&quot; >Wisconsin</option>

<option value=&quot;292&quot; >Wyoming</option>

</select>



<select name=&quot;txtField1_3&quot; >

<option value=&quot;&quot; >---- SELECT ----</option>

<option value=&quot;229&quot; >Alberta</option>

<option value=&quot;230&quot; >British Columbia</option>

<option value=&quot;231&quot; >Manitoba</option>

<option value=&quot;232&quot; >New Brunswick</option>

<option value=&quot;233&quot; >Newfoundland</option>

<option value=&quot;234&quot; >Northwest Territories</option>

<option value=&quot;235&quot; >Nova Scotia</option>

<option value=&quot;236&quot; >Nunavut</option>

<option value=&quot;237&quot; >Ontario</option>

<option value=&quot;238&quot; >Prince Edward Island</option>

<option value=&quot;239&quot; >Quebec</option>

<option value=&quot;240&quot; >Saskatchewan</option>

<option value=&quot;241&quot; >Yukon Territory</option>

</select>

I tossed in provinces (canada) and states (US) for fun

 

[JamesLean]

Obviously I can copy/paste the list from any number of sites. The key point of my question was creating the list automatically?

--James

 

[Digga]

Hi James,

no 'fraid not, not that I've heard.

You'll have to type it or copy the code provided. Once you have it in the DB you can call the data anytime you wish without a lot of typing.

Digga

Sharing Knowledge Saves Valuable Time!