String Comparison

[imperialized]

Ok guys, I am completely confused as to why this isnt working.. I've tried everything so I post it here.

 

$their_country = $x[location];
$country = mysql_query("SELECT * FROM countries ORDER BY id ASC");
while($z = mysql_fetch_array($country)){
$current_country = $z[country];
if($their_country <> $current_country){
	//not theirs
		print "<option value=\"$current_country\">$current_country</option>";
} else {
	//theirs
	print "<option value=\"$current_country\" SELECTED>$current_country</option>";
}
}

 

$their_country = prints France (which is good)

$current_country = prints whichever is pulled from the database in the loop (good too)

 

tried just using the $x[location] and $z[country] to compare, fails.

tried using === to compare, fails

tried putting quotes around each string in the if statement, fails

 

-- The code itself works, it just doesn't select the country. When (View Source) no option in the <select> menu has the SELECTED tag added to it.

[.josh]

so where is $x[location] being set?

[lonewolf217]

i wouldn't think that <> would take into account a case insensitive check.  try using strcasecmp() to see if it makes a difference. 

[imperialized]

if(strcasecmp($their_country,$current_country) <> 0){
	//not theirs
		print "<option value=\"$current_country\">$current_country</option>";
} else {
	//theirs
	print "<option value=\"$current_country\" SELECTED>$current_country</option>";
}

 

Still does not work..

 

$x[location] is set prior when I query the account info.

 

	//Get all of their account information.
							$get_account_query = mysql_query("SELECT * FROM poker_users WHERE poker_name = '$poker_name' LIMIT 1;");

							//Make sure the account exists 
							if(mysql_num_rows($get_account_query) > 0){
								//Account exists, make a loop!
								$x = mysql_fetch_assoc($get_account_query);

 

However, both of the variables print as they should... just wont compare correctly?

[.josh]

with strcasecmp you want to see if it equals zero.

[imperialized]

with strcasecmp you want to see if it equals zero.

 

 

Tried it both ways, makes no difference, although the reason I use <> is b/c the if statement decides which to print.

if its not 0, its not the same.

 

while($z = mysql_fetch_array($country)){
$current_country = $z[country];
if(strcasecmp($their_country,$current_country) == 0){
	//not theirs
	print "<option value=\"$current_country\" SELECTED>$current_country</option>";
} else {
	//their
	print "<option value=\"$current_country\">$current_country</option>";
}

[lonewolf217]

the only thing i can think of offhand would be trailing spaces or something in your data.

 

try doing this

<?php
var_dump($their_country);  // put this before the while loop
var_dump($current_country); // put this inside the while loop

?>

[.josh]

hmmm....

 

do this:

while($z = mysql_fetch_array($country)){
   $current_country = $z[country];
   echo $their_country . " : " . $current_country . "<br/>";
   if(strcasecmp($their_country,$current_country) == 0){
      //not theirs
      print "<option value=\"$current_country\" SELECTED>$current_country</option>";
   } else {
      //their
      print "<option value=\"$current_country\">$current_country</option>";
   }

 

post what that echo echoes out.

[imperialized]

hmmm....

 

do this:

while($z = mysql_fetch_array($country)){
   $current_country = $z[country];
   echo $their_country . " : " . $current_country . "<br/>";
   if(strcasecmp($their_country,$current_country) == 0){
      //not theirs
      print "<option value=\"$current_country\" SELECTED>$current_country</option>";
   } else {
      //their
      print "<option value=\"$current_country\">$current_country</option>";
   }

 

post what that echo echoes out.

 

 

I had to comment out the <select> in order to print the vars (cant print them inside, you know what im saying. but here is the result)

 

France : United States

France : Afghanistan

France : Albania

France : Algeria

France : American Samoa

France : Andorra

France : Angola

France : Anguilla

France : Antarctica

France : Antigua and Barbuda

France : Argentina

France : Armenia

France : Aruba

France : Austria

France : Azerbaijan

France : Bahamas

France : Bahrain

France : Bangladesh

France : Barbados

France : Belarus

France : Belgium

France : Belize

France : Benin

France : Bermuda

France : Bhutan

France : Bolivia

France : Bosnia and Herzegowina

France : Botswana

France : Bouvet Island

France : Brazil

France : British Indian Ocean Terr.

France : Brunei Darussalam

France : Bulgaria

France : Burkina Faso

France : Burundi

France : Cambodia

France : Cameroon

France : Cape Verde

France : Cayman Islands

France : Central African Republic

France : Chad

France : Chile

France : China

France : Christmas Island

France : Cocos (Keeling) Islands

France : Colombia

France : Comoros

France : Congo

France : Cook Islands

France : Costa Rica

France : Croatia (Hrvatska)

France : Cuba

France : Cyprus

France : Czech Republic

France : Denmark

France : Djibouti

France : Dominica

France : Dominican Republic

France : East Timor

France : Ecuador

France : Egypt

France : El Salvador

France : Equatorial Guinea

France : Eritrea

France : Estonia

France : Ethiopia

France : Falkland Islands/Malvinas

France : Faroe Islands

France : Fiji

France : Finland

France : France

France : France, Metropolitan

France : French Guiana

France : French Polynesia

France : French Southern Terr.

France : Gabon

France : Gambia

France : Georgia

France : Germany

France : Ghana

France : Gibraltar

France : Greece

France : Greenland

France : Grenada

France : Guadeloupe

France : Guam

France : Guatemala

France : Guinea

France : Guinea-Bissau

France : Guyana

France : Haiti

France : Heard & McDonald Is.

France : Honduras

France : Hong Kong

France : Hungary

France : Iceland

France : India

France : Indonesia

France : Iran

France : Iraq

France : Ireland

France : Israel

France : Italy

France : Jamaica

France : Japan

France : Jordan

France : Kazakhstan

France : Kenya

France : Kiribati

France : South Korea

France : Kuwait

France : Kyrgyzstan

France : Latvia

France : Lebanon

France : Lesotho

France : Liberia

France : Libyan Arab Jamahiriya

France : Liechtenstein

France : Lithuania

France : Luxembourg

France : Macau

France : Macedonia

France : Madagascar

France : Malawi

France : Malaysia

France : Maldives

France : Mali

France : Malta

France : Marshall Islands

France : Martinique

France : Mauritania

France : Mauritius

France : Mayotte

France : Mexico

France : Micronesia

France : Moldova

France : Monaco

France : Mongolia

France : Montserrat

France : Morocco

France : Mozambique

France : Myanmar

France : Namibia

France : Nauru

France : Nepal

France : Netherlands

France : Netherlands Antilles

France : New Caledonia

France : New Zealand

France : Nicaragua

France : Niger

France : Nigeria

France : Niue

France : Norfolk Island

France : Northern Mariana Is.

France : Norway

France : Oman

France : Pakistan

France : Palau

France : Panama

France : Papua New Guinea

France : Paraguay

France : Peru

France : Philippines

France : Pitcairn

France : Poland

France : Portugal

France : Puerto Rico

France : Qatar

France : Reunion

France : Romania

France : Russian Federation

France : Rwanda

France : Saint Kitts and Nevis

France : Saint Lucia

France : Samoa

France : San Marino

France : Sao Tome & Principe

France : Saudi Arabia

France : Senegal

France : Seychelles

France : Sierra Leone

France : Singapore

France : Slovakia

France : Slovenia

France : Solomon Islands

France : Somalia

France : South Africa

France : Spain

France : Sri Lanka

France : St. Helena

France : Sudan

France : Suriname

France : Swaziland

France : Sweden

France : Switzerland

France : Syrian Arab Republic

France : Taiwan

France : Tajikistan

France : Tanzania

France : Thailand

France : Togo

France : Tokelau

France : Tonga

France : Trinidad and Tobago

France : Tunisia

France : Turkey

France : Turkmenistan

France : Tuvalu

France : Uganda

France : Ukraine

France : United Arab Emirates

France : United Kingdom

France : U.S. Minor Outlying Is.

France : Uruguay

France : Uzbekistan

France : Vanuatu

France : Vatican

France : Venezuela

France : Viet Nam

France : Virgin Islands (British)

France : Virgin Islands (U.S.)

France : Western Sahara

France : Yemen

France : Yugoslavia

France : Zaire

France : Zambia

France : Zimbabwe

 

 

Code

$their_country = $x[location];
$country = mysql_query("SELECT * FROM countries ORDER BY id ASC");
while($z = mysql_fetch_array($country)){
   $current_country = $z[country];
   echo $their_country . " : " . $current_country . "<br/>";
   if(strcasecmp($their_country,$current_country) == 0){
      //not theirs
      //print "<option value=\"$current_country\" SELECTED>$current_country</option>";
   } else {
      //their
      //print "<option value=\"$current_country\">$current_country</option>";
   }
}

[.josh]

Yeah I'm suspecting the same thing as lonewolf: Some errant spacing or newline or tab char or something. Do this:

 

if(strcasecmp(trim($their_country),trim($current_country)) == 0){

 

That should hopefully do the trick.  If so, I recommend you backtrack in your script to where they are being put in the db in and trim them going into the db instead, though.

[imperialized]

Yeah I'm suspecting the same thing as lonewolf: Some errant spacing or newline or tab char or something. Do this:

 

if(strcasecmp(trim($their_country),trim($current_country)) == 0){

 

That should hopefully do the trick.  If so, I recommend you backtrack in your script to where they are being put in the db in and trim them going into the db instead, though.

 

 if(strcasecmp(trim($their_country),trim($current_country)) == 0){

 

Same thing, prints the list but doesnt select. This is driving me crazy! I've never had a problem like this before. I put the countries into the database using this txt file

 

countries.txt  (when highlighted, no spaces are shown at the end of lines)
United Kingdom
United States
Australia
New Zealand
Canada
France
South Africa
Afghanistan
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua and Barbuda
Argentina
Armenia
Aruba
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia and Herzegowina
Botswana
Bouvet Island
Brazil
British Indian Ocean Terr.
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Cape Verde
Cayman Islands
Central African Republic
Chad
Chile
China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Congo
Cook Islands
Costa Rica
Cote d'Ivoire
Croatia (Hrvatska)
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands/Malvinas
Faroe Islands
Fiji
Finland
France
France, Metropolitan
French Guiana
French Polynesia
French Southern Terr.
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guinea
Guinea-Bissau
Guyana
Haiti
Heard & McDonald Is.
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
South Korea
Kuwait
Kyrgyzstan
Lao People's Dem. Rep.
Latvia
Lebanon
Lesotho
Liberia
Libyan Arab Jamahiriya
Liechtenstein
Lithuania
Luxembourg
Macau
Macedonia
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Micronesia
Moldova
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Myanmar
Namibia
Nauru
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Northern Mariana Is.
Norway
Oman
Pakistan
Palau
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russian Federation
Rwanda
Saint Kitts and Nevis
Saint Lucia
Samoa
San Marino
Sao Tome & Principe
Saudi Arabia
Senegal
Seychelles
Sierra Leone
Singapore
Slovakia 
Slovenia
Solomon Islands
Somalia
South Africa
Spain
Sri Lanka
St. Helena
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syrian Arab Republic
Taiwan
Tajikistan
Tanzania
Thailand
Togo
Tokelau
Tonga
Trinidad and Tobago
Tunisia
Turkey
Turkmenistan
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
U.S. Minor Outlying Is.
Uruguay
Uzbekistan
Vanuatu
Vatican
Venezuela
Viet Nam
Virgin Islands (British)
Virgin Islands (U.S.)
Western Sahara
Yemen
Yugoslavia
Zaire
Zambia
Zimbabwe

 

When putting them into the database, it uses this:

 

<SELECT NAME="location" id="country_id" SIZE="1">
<OPTION VALUE="1"> Choose One </OPTION>
<OPTION VALUE="United Kingdom">United Kingdom</OPTION>
<OPTION VALUE="United States">United States</OPTION>
<OPTION VALUE="Australia">Australia</OPTION>
<OPTION VALUE="New Zealand">New Zealand</OPTION>
<OPTION VALUE="Canada">Canada</OPTION>

<OPTION VALUE="France">France</OPTION>
<OPTION VALUE="South Africa">South Africa</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="Antarctica">Antarctica</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="Austria">Austria</OPTION>
<OPTION VALUE="Azerbaijan">Azerbaijan</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 Herzegowina">Bosnia and Herzegowina</OPTION>
<OPTION VALUE="Botswana">Botswana</OPTION>
<OPTION VALUE="Bouvet Island">Bouvet Island</OPTION>
<OPTION VALUE="Brazil">Brazil</OPTION>
<OPTION VALUE="British Indian Ocean Terr.">British Indian Ocean Terr.</OPTION>
<OPTION VALUE="Brunei Darussalam">Brunei Darussalam</OPTION>
<OPTION VALUE="Bulgaria">Bulgaria</OPTION>
<OPTION VALUE="Burkina">Burkina Faso</OPTION>
<OPTION VALUE="Burundi">Burundi</OPTION>

<OPTION VALUE="Cambodia">Cambodia</OPTION>
<OPTION VALUE="Cameroon">Cameroon</OPTION>
<OPTION VALUE="Cape Verde">Cape Verde</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="Christmas Island">Christmas Island</OPTION>

<OPTION VALUE="Cocos (Keeling) Islands">Cocos (Keeling) Islands</OPTION>
<OPTION VALUE="Colombia">Colombia</OPTION>
<OPTION VALUE="Comoros">Comoros</OPTION>
<OPTION VALUE="Congo">Congo</OPTION>
<OPTION VALUE="Cook Islands">Cook Islands</OPTION>
<OPTION VALUE="Costa Rica">Costa Rica</OPTION>
<OPTION VALUE="Cote d'Ivoire">Cote d'Ivoire</OPTION>
<OPTION VALUE="Croatia (Hrvatska)">Croatia (Hrvatska)</OPTION>
<OPTION VALUE="Cuba">Cuba</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="East Timor">East Timor</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/Malvinas">Falkland Islands/Malvinas</OPTION>
<OPTION VALUE="Faroe Islands">Faroe Islands</OPTION>
<OPTION VALUE="Fiji">Fiji</OPTION>
<OPTION VALUE="Finland">Finland</OPTION>

<OPTION VALUE="France">France</OPTION>
<OPTION VALUE="France, Metropolitan">France, Metropolitan</OPTION>
<OPTION VALUE="French Guiana">French Guiana</OPTION>
<OPTION VALUE="French Polynesia">French Polynesia</OPTION>
<OPTION VALUE="French Southern Terr.">French Southern Terr.</OPTION>
<OPTION VALUE="Gabon">Gabon</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="Guinea">Guinea</OPTION>

<OPTION VALUE="Guinea-Bissau">Guinea-Bissau</OPTION>
<OPTION VALUE="Guyana">Guyana</OPTION>
<OPTION VALUE="Haiti">Haiti</OPTION>
<OPTION VALUE="Heard & McDonald Is.">Heard & McDonald Is.</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="Iran">Iran</OPTION>
<OPTION VALUE="Iraq">Iraq</OPTION>
<OPTION VALUE="Ireland">Ireland</OPTION>
<OPTION VALUE="Israel">Israel</OPTION>
<OPTION VALUE="Italy">Italy</OPTION>
<OPTION VALUE="Jamaica">Jamaica</OPTION>
<OPTION VALUE="Japan">Japan</OPTION>

<OPTION VALUE="Jordan">Jordan</OPTION>
<OPTION VALUE="Kazakhstan">Kazakhstan</OPTION>
<OPTION VALUE="Kenya">Kenya</OPTION>
<OPTION VALUE="Kiribati">Kiribati</OPTION>
<OPTION VALUE="South Korea">South Korea</OPTION>
<OPTION VALUE="Kuwait">Kuwait</OPTION>
<OPTION VALUE="Kyrgyzstan">Kyrgyzstan</OPTION>
<OPTION VALUE="Lao People's Dem. Rep.">Lao People's Dem. Rep.</OPTION>
<OPTION VALUE="Latvia">Latvia</OPTION>

<OPTION VALUE="Lebanon">Lebanon</OPTION>
<OPTION VALUE="Lesotho">Lesotho</OPTION>
<OPTION VALUE="Liberia">Liberia</OPTION>
<OPTION VALUE="Libyan Arab Jamahiriya">Libyan Arab Jamahiriya</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="Myanmar">Myanmar</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="Norfolk Island">Norfolk Island</OPTION>
<OPTION VALUE="Northern Mariana Is.">Northern Mariana Is.</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="Pitcairn">Pitcairn</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="Reunion">Reunion</OPTION>
<OPTION VALUE="Romania">Romania</OPTION>
<OPTION VALUE="Russian Federation">Russian Federation</OPTION>
<OPTION VALUE="Rwanda">Rwanda</OPTION>
<OPTION VALUE="Saint Kitts and Nevis">Saint Kitts and Nevis</OPTION>
<OPTION VALUE="Saint Lucia">Saint Lucia</OPTION>
<OPTION VALUE="Samoa">Samoa</OPTION>

<OPTION VALUE="San Marino">San Marino</OPTION>
<OPTION VALUE="Sao Tome & Principe">Sao Tome & Principe</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="St. Helena">St. Helena</OPTION>
<OPTION VALUE="Sudan">Sudan</OPTION>
<OPTION VALUE="Suriname">Suriname</OPTION>

<OPTION VALUE="Swaziland">Swaziland</OPTION>
<OPTION VALUE="Sweden">Sweden</OPTION>
<OPTION VALUE="Switzerland">Switzerland</OPTION>
<OPTION VALUE="Syrian Arab Republic">Syrian Arab Republic</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="Tokelau">Tokelau</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="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="U.S. Minor Outlying Is.">U.S. Minor Outlying Is.</OPTION>
<OPTION VALUE="Uruguay">Uruguay</OPTION>
<OPTION VALUE="Uzbekistan">Uzbekistan</OPTION>
<OPTION VALUE="Vanuatu">Vanuatu</OPTION>
<OPTION VALUE="Vatican">Vatican</OPTION>
<OPTION VALUE="Venezuela">Venezuela</OPTION>
<OPTION VALUE="Viet Nam">Viet Nam</OPTION>

<OPTION VALUE="Virgin Islands (British)">Virgin Islands (British)</OPTION>
<OPTION VALUE="Virgin Islands (U.S.)">Virgin Islands (U.S.)</OPTION>
<OPTION VALUE="Western Sahara">Western Sahara</OPTION>
<OPTION VALUE="Yemen">Yemen</OPTION>
<OPTION VALUE="Yugoslavia">Yugoslavia</OPTION>
<OPTION VALUE="Zaire">Zaire</OPTION>
<OPTION VALUE="Zambia">Zambia</OPTION>
<OPTION VALUE="Zimbabwe">Zimbabwe</OPTION>
</SELECT>

 

Sorry for the excessively long posts =\

 

It doesn't appear to be any spaces, however.

[imperialized]

Whoa wait a second... I restarted firefox and its working..  not sure when it started, b/c I was just using F5 to refresh the page. Well its working lol Thanks for all the help guys, I appr it.

[.josh]

Was gonna say... in a text file to db a \n is on the end of the line.  But trim should have taken care of that.  Was gonna next suggest changing

 

selected='selected'

 

instead of

 

SELECTED

 

(something you should do anyways)

 

 

[imperialized]

I'll make that change now

[.josh]

yeah you should also go ahead and either manually or write a quick script to trim your db entries to get rid of the \n's  so you don't have to have those trims in there.  data in dbs should be as unformatted as possible.