I have a PHP search. Currently, when no results are displayed the script shows and error. How can I make it display a message like "No Results found" when nothing is returned?
<?php
include("incls/connector.php");
$result = mysql_query("SELECT * FROM user WHERE username='$_POST[compName]'");
while($rowval = mysql_fetch_array($result))
{
$complainer = $rowval['username'];
$department = $rowval['department'];
$phonenumber = $rowval['phone_number'];
}
else
{
echo 'No Results were found';
}
mysql_close()
?>
mysql_close()missing semi colonIF