Search Error

[aaadee]

Hi, got a problem.

I have a search page using the following sql statement

$sql = "SELECT * FROM projmgrs WHERE id LIKE '%$search%' or customer LIKE '%$search%' or project_managers LIKE '%$search%' ORDER BY customer";

and i enter the search details, and it displays the correct results.

If i enter no details or a wrong details, it displayes nothing. Which is working, but i want it to say, your search did not find any or the correct results.

Please help.

Much Aprreciated.

Adam

[Anon]

If your using something like
$result=mysql_db_query($query,$link);
then you can do an IF based upon $result
IF (!$result){
echo "no results";
}else{
echo "results";
}