[RESOLVED] problem with string

vang

hi,

I'm having some problem with the below code.
I keep receiving the "failed" message even though $strB == "$country".
Which part did i done incorrectly?

$country is the country name in full capital letters.

		$sql = "SELECT $fieldvalue, $fieldname FROM $TableName";
		$result = mysql_query($sql) or die('Error, query failed');

	while($arrayRow = mysql_fetch_assoc($result))
	{	$strA = $arrayRow["$fieldvalue"];
		$strB = $arrayRow["$fieldname"];

		if ($strB == "$country")
		{	echo "success";
		}
		else
		{	echo "failed";
		}
	}

sohguanh

vang;10947255 wrote:
hi,

I'm having some problem with the below code.
I keep receiving the "failed" message even though $strB == "$country".
Which part did i done incorrectly?

$country is the country name in full capital letters.

Hi have you tried to print the contents of $strB and $country before doing the comparison ?

e.g

print_r($str😎;
print_r($country);

Thanks.

vang

Hi,

The previous issue is solved and it is not the root problem.
I tried to retrieve db data and put it in the drop down box.
Everything appears fine to me, but it does not show the selected value in the drop down box.
I copy the whole html code to display it and it works! The selected value appears in the drop down box.
I do not know why when i generate the html code for drop down box, the selected value did not appear!?
Both the generated html code and embedded html code looks the same to me.
Any idea?

<html>
Country
<?php
	echo "<select id=\"element_6\" name=\"element_6\" class=\"element select medium\">\n";
	echo "	<option value=\"\"></option>\n";

$sql = "SELECT country, country_name FROM wsd_countries ORDER BY country_name ASC";
$result = mysql_query($sql) or die('Error, query failed');

while($arrayRow = mysql_fetch_assoc($result))
{	$strAA = $arrayRow["country"];
	$strBB = $arrayRow["country_name"];

	$strA = strtoupper($strAA);
	$strB = strtoupper($strBB);

	if ($strB == $country)
	{	echo "	<option value=\"$strA\" selected>$strB</option>\n";
	}
	else
	{	echo "	<option value=\"$strA\">$strB</option>\n";
	}
}
echo "</select>";
?>
</html>