Search problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
djroadstar
Forum Newbie
Posts: 7
Joined: Mon Jan 15, 2007 5:41 pm

Search problem

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Can you post the SHOW CREATE TABLE for both tables?
Post Reply