Jump to content

Display certain page if no results from query?


Hangwire
 Share

Recommended Posts

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 :)

Link to comment
Share on other sites

<?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/>';
    }

?>

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.