Say "no hits" if no hits in SQL query ?

[developer]

Hello! 🙂

I do have this which works like a charm, how can I please change it so it says "No hits, try search again" if there is no hits please?

$Query="SELECT * FROM companies WHERE name LIKE '%" . $companyname . "%' " . $strCategory . $strTown;
$Result=mysql_db_query ("ghost_busdir", $Query, $dbh) or die (mysql_error());

while($row=mysql_fetch_array($Result))
{
echo "<b>";
echo $row['name'];
echo "</b>";
echo "<br>Contact person:";
echo $row['contactperson'];
echo "<br>";
echo $row['address'];
echo "<br>";
echo $row['areacode'];
echo "<p>";
}
?>

[Pig]

$Query="SELECT * FROM companies WHERE name LIKE '%" . $companyname . "%' " . $strCategory . $strTown; 
$Result=mysql_db_query ("ghost_busdir", $Query, $dbh) or die (mysql_error()); 
if( mysql_num_rows($Result) == 0 ) echo("No results.");
else
{
     while($row=mysql_fetch_array($Result)) 
     { 
     echo "<b>"; 
     echo $row['name']; 
     echo "</b>"; 
     echo "<br>Contact person:"; 
     echo $row['contactperson']; 
     echo "<br>"; 
     echo $row['address']; 
     echo "<br>"; 
     echo $row['areacode']; 
     echo "<p>"; 
     } 
}

[developer]

Thanks a lot for the help. 🙂