I'm using this code to search for keywords.
mysql_query("SELECT *, MATCH(keyword) AGAINST ('$keyword' IN BOOLEAN MODE)
FROM comment_library WHERE MATCH(keyword) AGAINST ('$keyword' IN BOOLEAN MODE)") or die ("Error ".mysql_error());
However it's doesn't seem to be working.
I'm getting this error:
You have an error in your SQL syntax near 'BOOLEAN MODE) FROM comment_library WHERE MATCH(keyword) AGAINST ('dumb' IN BOOLE' at line 1
What can you see that may be the cause of this?