How do I echo an error message when there are no hits in a search result in PHP?

  • Thread starter Thread starter H
  • Start date Start date
H

H

Guest
Hi, I am a PHP newbie, and I've tried this, but it doesn't work:


$result = mysql_query("SELECT * FROM book
WHERE BookID = '$bookid' AND Author = '$author' AND Title = '$title' AND Qualification = '$qual' OR (Qualification = '$qual' AND Subject = '$subject' OR Subject = '$other') OR Publisher = '$publisher' AND ISBN = '$isbn'");
echo $result;
if (empty($result)) {
echo 'Error, no such book found! Please check all the details and try again.';
}

Thanks
 
Back
Top