PHP Full Text Search Error

When you run the php website involved to full text search  that might be occurs this problem.

SQL query :

 
$q = "SELECT uname,post_date,subject,message FROM forum WHERE MATCH (message) 
AGAINST ( '$target') ORDER BY post_date ASC";


“Warning: mysqli_num_rows( ) expects parameter 1 to be
mysqli_result, boolean"

Database engine type : innoDB


You need to choose Full Text Search for the table.



SQL syntax :

ALTER TABLE FORUM ADD FULLTEXT(column )

Example



ALTER TABLE table_test  ADD FULLTEXT(message_test)