[SOLVED]mySQL error with Fulltext Search(match BOOLEAN), then mysqli_fetch_array() -

[SOLVED]mySQL error with Fulltext Search(match BOOLEAN), then mysqli_fetch_array() -

i have problem fulltext search (php,mysqli)

with sql works , no errors(not fulltextsearch). when run match doesnt work , wamp returns warning: mysqli_fetch_array() expects parameter 1 mysqli_result, boolean given in c:\wamp\www\myweb1

.... include 'connect_db.php'; $result = mysqli_query($con, "select * $cat title '%yte blade%' or description '%predam%' or locality '%predam%' "); //with works not fulltext search $result = mysqli_query($con, " select * $cat match (title,description,locality) against ('autobus' in boolean mode);"); while($row = mysqli_fetch_array($result)){....then display info

can help?

i solve that. problem muss set in phpmyadmin storage engine innodb myisam works. final fulltext search code was:

$result = mysqli_query($con,"select *, match(title, description, locality) against('$keyword') score $cat match(title, description, locality) against('$keyword') order score desc, create_date desc;");

thanks

full-text-search boolean match