Display certain page if no results from query?

[Hangwire]

Hello all. I'm using this code to go through the database and output certain user-defined numbers

 

 <?php
mysql_connect ("pdb1.awardspace.com", "anastasov_db","moscow1945")  or die (mysql_error());
mysql_select_db ("anastasov_db");

$term = $_POST['term'];

$sql = mysql_query("select * FROM countries WHERE cocode = '$term'");

while ($row = mysql_fetch_array($sql)){
    echo '<br/> Code: '.$row['cocode'];
    echo '<br/> Country: '.$row['coname'];
    echo '<br/><br/>';
    }

?>

 

Now how would I go about making a page that appears if the script can't find any results in the database?

 

Thank you in advance

[eMonk]

<?php
mysql_connect ("pdb1.awardspace.com", "anastasov_db","moscow1945")  or die (mysql_error());
mysql_select_db ("anastasov_db");

$term = $_POST['term'];

$sql = mysql_query("select * FROM countries WHERE cocode = '$term'");
$num_rows = mysql_num_rows($sql);

if ($num_rows == 0) {
echo "No results found.";
exit;
}

while ($row = mysql_fetch_array($sql)){
    echo '<br/> Code: '.$row['cocode'];
    echo '<br/> Country: '.$row['coname'];
    echo '<br/><br/>';
    }

?>

[Hangwire]

Thank you, I presume I can insert html code in the area between the comas?