note 16646 added to function.mysql-num-rows

Creating search feild but having problem with $num_mysql_rows. I have gone through endless documents and have found nothing which hints to the reason why? Error: Warning: Supplied argument is not a valid MySQL result resource in: CODE: mysql_select_db("reisa"); $SQL = "select * from agents where ".$searchtype." like '%".$searchterm."%'"; $result = mysql_query($SQL); $num = mysql_num_rows($result); No result is shown. Please help! -- http://www.php.net/manual/en/function.mysql-num-rows.php http://master.php.net/manage/user-notes.php?action=edit+16646 http://master.php.net/manage/user-notes.php?action=delete+16646 http://master.php.net/manage/user-notes.php?action=reject+16646