Page 1 of 1

Search problem

Posted: Sat Jan 27, 2007 7:53 am
by djroadstar
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:

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

Posted: Sat Jan 27, 2007 9:15 am
by feyd
Can you post the SHOW CREATE TABLE for both tables?