3-character-long php search engine problem
Posted: Mon Aug 15, 2005 7:48 pm
Hi everyone, I'm new to this forum and I hope there'll be someone out there who can help me out with this one.
Sometime ago I created a simple php search engine that searches for keywords in a MySQL database. (I'm using the MATCH - AGAINST method, and I don't wanna use the older method). Everything was doing fine until I had to move to another server. The problem now is that my search engine only searches for keywords longer than 3 characters. I wanna search for "dvd", for example, and my script finds nothing, but when I was in the previous server, it did.
I can't seem to find a solution for this problem and every solution I've tried has been to no avail. I'm pretty sure this has something to do with the server.
Can anyone help me out there?
Thanks beforehand.
ps: I've attached the sql query of my script.
Sometime ago I created a simple php search engine that searches for keywords in a MySQL database. (I'm using the MATCH - AGAINST method, and I don't wanna use the older method). Everything was doing fine until I had to move to another server. The problem now is that my search engine only searches for keywords longer than 3 characters. I wanna search for "dvd", for example, and my script finds nothing, but when I was in the previous server, it did.
I can't seem to find a solution for this problem and every solution I've tried has been to no avail. I'm pretty sure this has something to do with the server.
Can anyone help me out there?
Thanks beforehand.
ps: I've attached the sql query of my script.
Code: Select all
$results = mysql_query("SELECT * FROM Items WHERE MATCH (ItemName,ItemDescription) AGAINST ('$q' IN BOOLEAN MODE) LIMIT $page, $limit");