parse error 'else'

wendystewart80

The parse error is returned:
Parse error: parse error in c:\inetpub\wwwroot\Wendy\searchyouthservices.php on line 23

If I remove the 'else' function it works but the 'sorry no matches' message is returned even when there are matches.

Here's my code:

<?php
mysql_connect ("localhost", "root", "purple1");
mysql_select_db ('youth_services');
$search=$_POST["search"];
$result = mysql_query("SELECT * FROM details WHERE org LIKE '%$search%'");
while($r=mysql_fetch_array($result))
{
$org=$r["org"];
$address1=$r["address1"];
$city=$r["city"];
$pcode=$r["pcode"];
$tel=$r["tel"];
$email=$r["email"];

echo "$org $address1 $city $pcode $tel $email ";}
else {echo "Sorry, no results found";
}
?>

I can't figure out what is wrong with having 'else' there.

Anyone got any suggestions?

Many thanks

bodzan

...and since else works only if there is a if before (hence the term if/else statement) you won't be able to get this working that way...

So I suggest:

if(mysql_num_rows($result)>0){
//do while statement
}
else{
//echo your sorry
}

wendystewart80

Thanks Bodzan.
Your suggestion worked a treat.
All the best