混淆在PHP中生成错误消息

Question

all this code is work, what left is I try to echo a message if query not find anything..

include("config.php");

$search = $_POST['search'];  

$sql = mysql_query("SELECT * FROM barangtbl WHERE nama LIKE '%$search%' ") or die(mysql_error());  
  while ($res=mysql_fetch_array($sql)) {  
    echo $res['nama'].'<br>';  
  } 


?> 

Answer 1

Write this:

if(mysql_num_rows($sql)) {
  while ($res=mysql_fetch_array($sql)) {  
    echo $res['nama'].'<br>';  
  } 
}
else
{
 echo "Not found";
}