Full Text search returning zero results
Posted: Mon Sep 17, 2007 11:19 am
Hey, I had my full text search working previously, although recently we moved to a different server, now whenever I search I get zero results, even though there is data in the database and we haven't change the script.
Here's the query I'm using:
This returns 0 results, however this:
DOES return results, but they are not ordered correctly and aren't as relevant than what I had with the script on the old server.
I have the FULL TEXT index setup in the db on the columns data and keydate.
Cheers, Hope someone can help
Joe
Here's the query I'm using:
Code: Select all
$query2="SELECT * , MATCH(`data`, `keydate`) AGAINST('$q') AS score
FROM `dataindex` WHERE `userid`='$userid' AND MATCH(`data`, `keydate`) AGAINST('$q') ORDER BY score DESC ";Code: Select all
$query2="SELECT * , MATCH(`data`, `keydate`) AGAINST('$q') AS score
FROM `dataindex`ORDER BY score DESC ";I have the FULL TEXT index setup in the db on the columns data and keydate.
Cheers, Hope someone can help
Joe