Smarter Results...

[baqup]

Hello,
I have web page that returns a number of results based off of a keywords, but the results don't always seem to be always relevant.

I am wanting to change the script so that it returns results based off of at least two of the keywords matching instead of just one. This will definately make the results more relevant, but i don't know how to actually accomplish this.

Currently, this is what i have that returns the end results using just one of the keywords.

---

The keywords are generated by:
$getkeywords="select c1_NAME from TableA union select c1_NAME from TableB";

This returns about a total of 15 names or so.
This is then called by my main page with:

$sql="select * from news WHERE MATCH (description) AGAINST ('$keywords_search' IN BOOLEAN MODE) order by date_time desc limit 0,25";

---

Can anyone help me tweak this?

I really appreciate your help.

Thanks!

[doobster]

This is always a very tough thing to accomplish. A potential simplier solution is to use the relevance.

SELECT 
     MATCH('Content') AGAINST ('keyword1 keyword2') as Relevance 
FROM table 
WHERE MATCH ('Content') 
   AGAINST('+keyword1 +keyword2' IN BOOLEAN MODE) 
HAVING Relevance > 0.2 ORDER 
BY Relevance DESC

This is a comment from Mysql's full text page: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

The other way that might be a potential solution is to use something like Jquery autocomplete.