Mysqli, php - MATCH AGAINST for searching.

[Simber33]

Hello,

I'm trying to create a script which searchs through several columns in a table, using a keyword to search. I use mysqli and a query with MATCH AGAINST. I have got a code but it does not work and I do not know why. It does not give any error, but it basicly returns nothing. Here is my code:

 

<?php
if (isset($_POST['submit'])) {
    $tag = $_POST['tag'];
   
include("database/database.php");
      
    $query = ("SELECT Tutorialid, Title, Author FROM tutorials  WHERE MATCH (Title, Body1, Body2, Body3, Body4, Author) AGAINST (?)");      
        
              
   if ($stmt = $connection->prepare($query)){


$stmt->bind_param("s",$tag);
$stmt->execute();


$stmt->bind_result($id, $title, $author);

$html_table = '</br></br><table class="cats" cellpadding="10" cellspacing="0">
   
        <tr>

             <th class="cath">Title</th>
             <th class="cath">Author</th>
<th class="cath">Link</th>  
                            </tr>';



while ($stmt->fetch())
 {
    


$link = "<a href='http://everytutorial.net/tutorials/".$id."'>Click here to open</a>";

$html_table .= '<tr><td class="catd">' .$title. '</td><td class="catd">' .$author.'</td><td class="catd">'.$link.'</td></tr>';
   

}
$html_table .='</table></br></br></br>';

if (empty($id))
 {
 echo "<p>No tutorials found milord.</p>";
 }
 
 
 else {
echo $html_table;

$stmt->free_result();
$connection->close();
}
}
}

 

I'm not sure what's wrong with it - any help could be great, thanks!