Populate a select list with items in a database

[Andros]

Hi Dody, I know this is not part of Indexu and you do not have to reply if you do not want to, but is it possible that you can give me the code to populate a select list with items in a database. I have a field name "country" which all members that submit their sites fill in. What I like to do is to populate the country list in a drop down list form so that when someone is choosing a country it will take him to the links under that country. If you can assist I will be greatful.

Thank you
Andros

[dody]

Hi Andros, I hope this can be useful.
I split into 2 post because vbulletin doesn't allow me (too long)


<select name=country>
<OPTION VALUE=''></OPTION>
<option value='Afghanistan'>Afghanistan</OPTION>
<option value='Albania'>Albania</OPTION>
<option value='Algeria'>Algeria</OPTION>
<option value='American Samoa'>American Samoa</OPTION>
<option value='Andorra'>Andorra</OPTION>
<option value='Angola'>Angola</OPTION>
<option value='Anguilla'>Anguilla</OPTION>
<option value='Antigua and Barbuda'>Antigua and Barbuda</OPTION>
<option value='Argentina'>Argentina</OPTION>
<option value='Armenia'>Armenia</OPTION>
<option value='Aruba'>Aruba</OPTION>
<option value='Australia'>Australia</OPTION>
<option value='Austria'>Austria</OPTION>
<option value='Azerbaijan Republic'>Azerbaijan Republic</OPTION>
<option value='Bahamas'>Bahamas</OPTION>
<option value='Bahrain'>Bahrain</OPTION>
<option value='Bangladesh'>Bangladesh</OPTION>
<option value='Barbados'>Barbados</OPTION>
<option value='Belarus'>Belarus</OPTION>
<option value='Belgium'>Belgium</OPTION>
<option value='Belize'>Belize</OPTION>
<option value='Benin'>Benin</OPTION>
<option value='Bermuda'>Bermuda</OPTION>
<option value='Bhutan'>Bhutan</OPTION>
<option value='Bolivia'>Bolivia</OPTION>
<option value='Bosnia and Herzegovina'>Bosnia and Herzegovina</OPTION>
<option value='Botswana'>Botswana</OPTION>
<option value='Brazil'>Brazil</OPTION>
<option value='British Virgin Islands'>British Virgin Islands</OPTION>
<option value='Brunei Darussalam'>Brunei Darussalam</OPTION>
<option value='Bulgaria'>Bulgaria</OPTION>
<option value='Burkina Faso'>Burkina Faso</OPTION>
<option value='Burma'>Burma</OPTION>
<option value='Burundi'>Burundi</OPTION>
<option value='Cambodia'>Cambodia</OPTION>
<option value='Cameroon'>Cameroon</OPTION>
<option value='Canada'>Canada</OPTION>
<option value='Cape Verde Islands'>Cape Verde Islands</OPTION>
<option value='Cayman Islands'>Cayman Islands</OPTION>
<option value='Central African Republic'>Central African Republic</OPTION>
<option value='Chad'>Chad</OPTION>
<option value='Chile'>Chile</OPTION>
<option value='China'>China</OPTION>
<option value='Colombia'>Colombia</OPTION>
<option value='Comoros'>Comoros</OPTION>
<option value='Congo, Democratic Republic of the'>Congo, Democratic Republic of the</OPTION>
<option value='Congo, Republic of the'>Congo, Republic of the</OPTION>
<option value='Cook Islands'>Cook Islands</OPTION>
<option value='Costa Rica'>Costa Rica</OPTION>
<option value='Cote d Ivoire (Ivory Coast)'>Cote d Ivoire (Ivory Coast)</OPTION>
<option value='Croatia, Democratic Republic of the'>Croatia, Democratic Republic of the</OPTION>
<option value='Cyprus'>Cyprus</OPTION>
<option value='Czech Republic'>Czech Republic</OPTION>
<option value='Denmark'>Denmark</OPTION>
<option value='Djibouti'>Djibouti</OPTION>
<option value='Dominica'>Dominica</OPTION>
<option value='Dominican Republic'>Dominican Republic</OPTION>
<option value='Ecuador'>Ecuador</OPTION>
<option value='Egypt'>Egypt</OPTION>
<option value='El Salvador'>El Salvador</OPTION>
<option value='Equatorial Guinea'>Equatorial Guinea</OPTION>
<option value='Eritrea'>Eritrea</OPTION>
<option value='Estonia'>Estonia</OPTION>
<option value='Ethiopia'>Ethiopia</OPTION>
<option value='Falkland Islands (Islas Malvinas)'>Falkland Islands (Islas Malvinas)</OPTION>
<option value='Fiji'>Fiji</OPTION>
<option value='Finland'>Finland</OPTION>
<option value='France'>France</OPTION>
<option value='French Guiana'>French Guiana</OPTION>
<option value='French Polynesia'>French Polynesia</OPTION>
<option value='Gabon Republic'>Gabon Republic</OPTION>
<option value='Gambia'>Gambia</OPTION>
<option value='Georgia'>Georgia</OPTION>
<option value='Germany'>Germany</OPTION>
<option value='Ghana'>Ghana</OPTION>
<option value='Gibraltar'>Gibraltar</OPTION>
<option value='Greece'>Greece</OPTION>
<option value='Greenland'>Greenland</OPTION>
<option value='Grenada'>Grenada</OPTION>
<option value='Guadeloupe'>Guadeloupe</OPTION>
<option value='Guam'>Guam</OPTION>
<option value='Guatemala'>Guatemala</OPTION>
<option value='Guernsey'>Guernsey</OPTION>
<option value='Guinea'>Guinea</OPTION>
<option value='Guinea-Bissau'>Guinea-Bissau</OPTION>
<option value='Guyana'>Guyana</OPTION>
<option value='Haiti'>Haiti</OPTION>
<option value='Honduras'>Honduras</OPTION>
<option value='Hong Kong'>Hong Kong</OPTION>
<option value='Hungary'>Hungary</OPTION>
<option value='Iceland'>Iceland</OPTION>
<option value='India'>India</OPTION>
<option value='Indonesia'>Indonesia</OPTION>
<option value='Ireland'>Ireland</OPTION>
<option value='Israel'>Israel</OPTION>
<option value='Italy'>Italy</OPTION>
<option value='Jamaica'>Jamaica</OPTION>
<option value='Jan Mayen'>Jan Mayen</OPTION>
<option value='Japan'>Japan</OPTION>
<option value='Jersey'>Jersey</OPTION>
<option value='Jordan'>Jordan</OPTION>
<option value='Kazakhstan'>Kazakhstan</OPTION>
<option value='Kenya Coast Republic'>Kenya Coast Republic</OPTION>
<option value='Kiribati'>Kiribati</OPTION>
<option value='Korea, South'>Korea, South</OPTION>
<option value='Kuwait'>Kuwait</OPTION>
<option value='Kyrgyzstan'>Kyrgyzstan</OPTION>
<option value='Laos'>Laos</OPTION>
<option value='Latvia'>Latvia</OPTION>
<option value='Lebanon'>Lebanon</OPTION>
<option value='Lesotho'>Lesotho</OPTION>
<option value='Liberia'>Liberia</OPTION>
<option value='Liechtenstein'>Liechtenstein</OPTION>
<option value='Lithuania'>Lithuania</OPTION>
<option value='Luxembourg'>Luxembourg</OPTION>
<option value='Macau'>Macau</OPTION>
<option value='Macedonia'>Macedonia</OPTION>
<option value='Madagascar'>Madagascar</OPTION>
<option value='Malawi'>Malawi</OPTION>
<option value='Malaysia'>Malaysia</OPTION>
<option value='Maldives'>Maldives</OPTION>
<option value='Mali'>Mali</OPTION>
<option value='Malta'>Malta</OPTION>
<option value='Marshall Islands'>Marshall Islands</OPTION>
<option value='Martinique'>Martinique</OPTION>
<option value='Mauritania'>Mauritania</OPTION>
<option value='Mauritius'>Mauritius</OPTION>
<option value='Mayotte'>Mayotte</OPTION>
<option value='Mexico'>Mexico</OPTION>
<option value='Micronesia'>Micronesia</OPTION>
<option value='Moldova'>Moldova</OPTION>
<option value='Monaco'>Monaco</OPTION>
<option value='Mongolia'>Mongolia</OPTION>
<option value='Montserrat'>Montserrat</OPTION>
<option value='Morocco'>Morocco</OPTION>
<option value='Mozambique'>Mozambique</OPTION>
<option value='Namibia'>Namibia</OPTION>
<option value='Nauru'>Nauru</OPTION>
<option value='Nepal'>Nepal</OPTION>
<option value='Netherlands'>Netherlands</OPTION>
<option value='Netherlands Antilles'>Netherlands Antilles</OPTION>
<option value='New Caledonia'>New Caledonia</OPTION>
<option value='New Zealand'>New Zealand</OPTION>
<option value='Nicaragua'>Nicaragua</OPTION>
<option value='Niger'>Niger</OPTION>
<option value='Nigeria'>Nigeria</OPTION>
<option value='Niue'>Niue</OPTION>
<option value='Norway'>Norway</OPTION>
<option value='Oman'>Oman</OPTION>
<option value='Pakistan'>Pakistan</OPTION>
<option value='Palau'>Palau</OPTION>
<option value='Panama'>Panama</OPTION>
<option value='Papua New Guinea'>Papua New Guinea</OPTION>
<option value='Paraguay'>Paraguay</OPTION>
<option value='Peru'>Peru</OPTION>
<option value='Philippines'>Philippines</OPTION>
<option value='Poland'>Poland</OPTION>
<option value='Portugal'>Portugal</OPTION>
<option value='Puerto Rico'>Puerto Rico</OPTION>
<option value='Qatar'>Qatar</OPTION>
<option value='Romania'>Romania</OPTION>
<option value='Russian Federation'>Russian Federation</OPTION>
<option value='Rwanda'>Rwanda</OPTION>

[dody]

...continue



<option value='Saint Helena'>Saint Helena</OPTION>
<option value='Saint Kitts-Nevis'>Saint Kitts-Nevis</OPTION>
<option value='Saint Lucia'>Saint Lucia</OPTION>
<option value='Saint Pierre and Miquelon'>Saint Pierre and Miquelon</OPTION>
<option value='Saint Vincent and the Grenadines'>Saint Vincent and the Grenadines</OPTION>
<option value='San Marino'>San Marino</OPTION>
<option value='Saudi Arabia'>Saudi Arabia</OPTION>
<option value='Senegal'>Senegal</OPTION>
<option value='Seychelles'>Seychelles</OPTION>
<option value='Sierra Leone'>Sierra Leone</OPTION>
<option value='Singapore'>Singapore</OPTION>
<option value='Slovakia'>Slovakia</OPTION>
<option value='Slovenia'>Slovenia</OPTION>
<option value='Solomon Islands'>Solomon Islands</OPTION>
<option value='Somalia'>Somalia</OPTION>
<option value='South Africa'>South Africa</OPTION>
<option value='Spain'>Spain</OPTION>
<option value='Sri Lanka'>Sri Lanka</OPTION>
<option value='Sudan'>Sudan</OPTION>
<option value='Suriname'>Suriname</OPTION>
<option value='Svalbard'>Svalbard</OPTION>
<option value='Swaziland'>Swaziland</OPTION>
<option value='Sweden'>Sweden</OPTION>
<option value='Switzerland'>Switzerland</OPTION>
<option value='Syria'>Syria</OPTION>
<option value='Tahiti'>Tahiti</OPTION>
<option value='Taiwan'>Taiwan</OPTION>
<option value='Tajikistan'>Tajikistan</OPTION>
<option value='Tanzania'>Tanzania</OPTION>
<option value='Thailand'>Thailand</OPTION>
<option value='Togo'>Togo</OPTION>
<option value='Tonga'>Tonga</OPTION>
<option value='Trinidad and Tobago'>Trinidad and Tobago</OPTION>
<option value='Tunisia'>Tunisia</OPTION>
<option value='Turkey'>Turkey</OPTION>
<option value='Turkmenistan'>Turkmenistan</OPTION>
<option value='Turks and Caicos Islands'>Turks and Caicos Islands</OPTION>
<option value='Tuvalu'>Tuvalu</OPTION>
<option value='Uganda'>Uganda</OPTION>
<option value='Ukraine'>Ukraine</OPTION>
<option value='United Arab Emirates'>United Arab Emirates</OPTION>
<option value='United Kingdom'>United Kingdom</OPTION>
<option value='United States'>United States</OPTION>
<option value='Uruguay'>Uruguay</OPTION>
<option value='Uzbekistan'>Uzbekistan</OPTION>
<option value='Vanuatu'>Vanuatu</OPTION>
<option value='Vatican City State'>Vatican City State</OPTION>
<option value='Venezuela'>Venezuela</OPTION>
<option value='Vietnam'>Vietnam</OPTION>
<option value='Virgin Islands (U.S.)'>Virgin Islands (U.S.)</OPTION>
<option value='Wallis and Futuna'>Wallis and Futuna</OPTION>
<option value='Western Sahara'>Western Sahara</OPTION>
<option value='Western Samoa'>Western Samoa</OPTION>
<option value='Yemen'>Yemen</OPTION>
<option value='Yugoslavia'>Yugoslavia</OPTION>
<option value='Zambia'>Zambia</OPTION>
<option value='Zimbabwe'>Zimbabwe</OPTION>
</select>

[Andros]

Thanks dody, but what i really wanted is the code to generate dynamically the drop down list of the countries already submited by the users and reside in the database in the Idx_link table. Sorry for not clarifying this before..

thx again,
andros

[Andros]

Can anyone help concering the question above??

thank you