Hi there,
I have a problam with my code, and i cant fix it, please help.
The problam is with the mysql_num_rows on line 4 ;
Here is the code:
$sql_query = mysql_query("SELECT * FROM upload WHERE MATCH(username,text) AGAINST('$search_term')");
//additional check. Insurance method to re-search the database again in case of too many matches (too many matches cause returning of 0 results)
if($results = mysql_num_rows($sql_query) != 0) //Error on this line !!!!
{
$sql = "SELECT * FROM upload WHERE MATCH(username,subject) AGAINST('$search_term') LIMIT $first_pos, $RESULTS_LIMIT";
$sql_result_query = mysql_query($sql);
}
Thanks for your help!