I have to perform a search function…
where if the search text is “mobile phones”…
i want to search text which matches like ‘mobile phones’,‘phones mobile’,‘phones’ or ‘mobile’ from the table fields…
i did something like following,
[code]$sql_search=“SELECT txtname, txtdescription, txtlongdescription
FROM items WHERE MATCH( txtname, txtdescription, txtlongdescription) AGAINST (’$searchword’)”;
$result = mysql_query($sql_search);
printf("Results: <br />");
while ($row = mysql_fetch_array($result) or die (mysql_error())) {
echo $row['txtname']."<br>";
}[/code]
but when i run the script it says…
The used table type doesn’t support FULLTEXT indexes