Re: Improving Ranking of search results in a product search script

[fatjoe slim]

Gotten a bit further:

$query = 'select *, ((MATCH(`title`) AGAINST ("'.$word.'"))*2)+((MATCH(`description`) AGAINST ("'.$word.'"))) AS relevancy FROM '.$prefix.'store_inventory where MATCH(`title`) AGAINST ("'.$word.'") and MATCH(`description`) AGAINST ("'.$word.'") ORDER BY relevancy DESC '.$limitvalue.', '.$limit.'';

Few problems remain:

1. If $word = 'windows xp' Query finds results with Windows OR xp in the title/description. It should be searching for Windows AND xp

2. Page number has gone beserk because search.php uses a different query to generate page numbers -.-!!!

3. A search for "Gaming" does not return a product with the title "Athlon 64 Gaming System"... Uncertain as to why...

Help on either problem by anyone is appreciated