Code: Select all
<?php
$q=$_GET["q"];
include "dbconn.php";
$result = mysql_query ("SELECT * FROM faq WHERE MATCH(question,answer) AGAINST ('$q')")or die(mysql_error());
$num_rows = mysql_num_rows($result);
if ($num_rows == 1) { echo "<div class='sectionhead'>Does this answer your question?</div>";}
if ($num_rows > 1) { echo "<div class='sectionhead'>Do these answer your question?</div>";}
while ($row = mysql_fetch_object($result)){
echo "<i>$row->question</i><br/>$row->answer<hr noshade size='1' />";
} mysql_free_result($result);
mysql_close($sqlconn);
?>[text]Can't find FULLTEXT index matching the column list[/text]
Why?