This is the code for the search function:
Code: Select all
$sql = "SELECT *,
MATCH(field1, field2, field3, field4)
AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM tbl_tabel
WHERE MATCH(field1, field2, field3, field4)
AGAINST ('$searchstring' IN BOOLEAN MODE) and status='active' ORDER BY score DESC";Code: Select all
A live preview of my search function is: http://www.koopeenpaard.nl/includes/pag ... ame=Zoeken