Improving search results

[madmouse]

rob, thank you for this code. i'm hoping to get it to work. i did the text indexing and put the code changes above into my header_php.php file, but it's not working (as far as i can tell). you reference something called 'robs_keywords'... how do i define that for my own site? ultimately i'm hoping to have this sort search results by product category, then products name if possible. do you think that is possible? thanks!

the variable robs_keywords is defined in the code above. Are you using the latest version of Zen? Sorry I don't have much time to support this.

Rob

[fontaholic]

thanks so much for replying. i'm on 1.3.8a right now on my live server but am in the process of cleaning up my dev version to upgrade to 1.3.9. if i need to wait to do this untill then, i can add it to my post-upgrade list!

[madmouse]

Looks like I'm still on 1.3.8 so that's probably not the problem.

Rob

[madmouse]

It might be because you have "Advanced Search 1.1" installed? I've not seen that mod but looks interesting, when I get some spare time I will try installing it and see how it works with my changes.

Rob

[howitzer]

Rob, thank you sharing this solution. It has saved me loads of time and effort. Works like a dream.

[stumpyhead123]

rob, thank you for this code. i'm hoping to get it to work. i did the text indexing and put the code changes above into my header_php.php file, but it's not working (as far as i can tell). you reference something called 'robs_keywords'... how do i define that for my own site? ultimately i'm hoping to have this sort search results by product category, then products name if possible. do you think that is possible? thanks!

SWEEEEEEEET!!!! that sorted it right out. top notch!!!

[stumpyhead123]

Nice one! that sorted my search out loads; there's still a few stragglers here and there but it's infinitely better! thanks man i really appreciate that!

[vooboo13]

I just performed the mod on my 1.3.9h store and it works great! I just need to do the additional modification to the mysql config file to account for the 3 letter words. Thanks for posting the code!

[llynix]

// Ranking code by Rob - www.funkyraw.com
$robs_keywords=stripslashes($_GET['keyword']);
$from_str = ", MATCH(pd.products_name) AGAINST('$robs_keywords') AS rank1, MATCH(pd.products_description) AGAINST('$robs_keywords') AS rank2 ";
//end ranking code

Just a note. In 1.5.1 the $robs_keywords=stripslashes($_GET['keyword']); line breaks searches containing a single quote. Commenting it out fixes it.

[nicksoftsol]

Just a note. In 1.5.1 the $robs_keywords=stripslashes($_GET['keyword']); line breaks searches containing a single quote. Commenting it out fixes it.

Thank you! I just discovered this in 1.5.0, so you saved me a lot of time searching for a fix.