echo message if no records found from database
<p>I have created a search box that will pull certain parameters from the MySQL database. What code would I need to embed into the following code if no parameters occurred causing the echo text to inform the user that no matching parameters could be great.</p>

<pre><code>&lt;?php
mysql_connect ("localhost", "root", "")  or die (mysql_error());
mysql_select_db ("store_location");

$term = $_POST['term'];

$sql = mysql_query("SELECT * FROM store_location where store_name like '%$term%' or     address like '%$term%' or city like '%$term%' or state like '%$term%' or zip like     '%$term%' or phone like '%$term%' or fax like '%$term%' or email like '%$term%' or url     like '%$term%' ");

echo '&lt;h1&gt;Search Results:&lt;/h1&gt;';

while ($row = mysql_fetch_array($sql)){

echo 'Store Name: '.$row['store_name'];
echo '&lt;br/&gt; Address: '.$row['address'];
echo '&lt;br/&gt; City: '.$row['city'];
echo '&lt;br/&gt; State: '.$row['state'];
echo '&lt;br/&gt; Zip: '.$row['zip'];
echo '&lt;br/&gt; Phone: '.$row['phone'];
echo '&lt;br/&gt; Fax: '.$row['fax'];
echo '&lt;br/&gt; Email: &lt;a href="mailto:'.$row['email'].'"&gt;'.$row['email'].'&lt;/a&gt;';
echo '&lt;br/&gt; URL: &lt;a href="'.$row['url'].'"&gt;'.$row['url'].'&lt;/a&gt;';
echo '&lt;br/&gt;&lt;br/&gt;';
}

?&gt;
</code></pre>
