MySQL Fulltext Index Search won't work!
Posted on 2005-04-21
Hope you can help, I am stuck.
I've got a table called tblquestions.
In it is a table called questions, with the following fields:
questionID, int, 6
question, varchar, 255
answer, varchar, 255
The question column has a fulltext index and I am trying to query it using the following sql statement:
$strSQL = SELECT questionID, question, answer FROM tblquestions WHERE MATCH (question) AGAINST ('" . $theQuestion . "')";
For some reason it tells me I haev an error in my sql statement, but if I echo the statement and execute it against the database directly with my MySQL GUI it doesn't give me an error. I have tried it with and without funny characters like apostrophies to no avail. Even odder, is that although I don't get an error when I execute the statement with the GUI, it still finds no matches, even though I know for sure there is a match. I have an identical SQL Statement working just fine on another site I built so this driving me bananas now!
Hope you can help!
Many thanks in anticipation!