select statement

[rowantrimmer]

I have the following PHP code but $country does not pull anything out of the database although when I echo it it does contains someting.

$db=mysql_connect("localhost",$world_user,$world_pass);

mysql_select_db($world_data,$db);

$result = mysql_query("SELECT * FROM agentdata where region = '$country' Order by region",$db);

$count=mysql_num_rows($result);


if ($myrow = mysql_fetch_array($result))

I assume that I have my select syntax incorrect ?

Any ideas ?

Regards

Rowan

[eoghain]

Your query looks fine. Does the data in $country exactly match data in your region field? When you use an = in your where clause you are saying that they exactly match. So if you have 'Uganda' in the database and the $country variable holds 'uganda' you won't get a match.

[LordShryku]

Sometimes, an easy way around this is to force upper or lower casing on your query.

"SELECT * FROM agentdata where upper(region) = upper('$country') Order by region"

Don't know about mySQL, but it does wonders with Oracle. 🙂

[xblue]

mysql does not match case-sensitive on text and varchar fields.

you can force it with the binary keyword, but I don't think that's the problem here.

Rowan, try echoing the query to see if it looks as you want it to look:

$sql = "SELECT * FROM agentdata where region = '$country' Order by region";
echo $sql."<br />";
$result = mysql_query($sql, $db) or die(mysql_error()); 

btw, please put code in [php] [/php] tags, this makes it easier to read.