I tried this statement and I didn't get any results even though there are about 10 other topics with the exact same title ($title). Am I doing something wrong or missing something? I thought I understood full text but apparently not lol. I do not get any mysql error, I just get 0 results. Also, I tried only matching topic_title against $title and get nothing. IF anyone has used this before and can give me any tips I would really appreciate it.
Code: Select all
$query="SELECT *,
MATCH(topic_title, description) AGAINST('$title') AS score
FROM topic
WHERE MATCH(topic_title, description) AGAINST('$title')
ORDER BY score DESC LIMIT 10";
$result1=mysql_query($query) or die('Error, select query failed');