mysql in boolean mode error

[kalster]

why is this code not working? in php i have the following...

$keywords = "+hello +world";
$query= "SELECT * FROM forums WHERE MATCH (topics) AGAINST ('$keywords' IN BOOLEAN MODE)";
$results = mysqli_query($database, $query);
$row =  mysqli_fetch_assoc($results);

$topics = $row['topics'];
echo $topics;

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given...

[requinix]

Have you tried using mysqli_error to get an error message?

[kalster]

I just tried mysql_error for the first time. Errormessage: The used table type doesn't support FULLTEXT indexes.

ENGINE=MyISAM solved the problem. thank you.

[QuickOldCar]

mysql version 5.6+ supports fulltext boolean for innodb

Edited October 15, 2014 by QuickOldCar

[kalster]

How can I get the following to work? The code does not work when $author is emtpy. I need the code to work when the $author string is empty or not. Thank you in advanced.

$query= "SELECT * FROM forums WHERE MATCH (topics) AGAINST ('$keywords' IN BOOLEAN MODE) 
AND MATCH (users) AGAINST ('$author' IN BOOLEAN MODE)";

Edited October 15, 2014 by kalster

[kalster]

The post above was fixed by a php if statement to determine if the $author variable was empty

Edited October 15, 2014 by kalster