Search problem
Posted: Sat Jan 27, 2007 7:53 am
I have a problem with my search function. At my external webserver the search function is case sensitive and at my local webserver it,s not case sensitive. The Collation is latin1_swedish_ci. I don,t want to be my search function is case sensitive. I,m also using "FULLTEXT index".
This is the code for the search function:
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