RE: [PHP] Re: Rating results after relevance. Difficult problem
| From: | Lauri Vain | Date: | Thu, 09 May 2002 09:55:23 +0000 |
| Subject: | RE: [PHP] Re: Rating results after relevance. Difficult problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-96789@lists.php.net to get a copy of this message | ||
Andy and all,
> wow! Sven's idea works just great!
Yes, isn't it great?!!
You can actually extend it even further and even implement boolean
expressions.
I remember a great article somewhere (let me see whether I can dig it up
from somewhere).
Ok, here it is:
http://www.evolt.org/article/Boolean_Fulltext_Searching_with_PHP_and_MyS
QL/18/15665/index.html
I have used a really similar approach by many sites and it has worked
great so far. There are downsides to it compared to "SELECT id,name FROM
art WHERE content LIKE '%string%'" (speed), but the advantages surely
beat the living crap out of this (unless you get three
billion-zillion-gazillion hits per day).
Enjoy!
Thanks,
Lauri
--
Tharapita Creations
[server-client web applications]
lauri.vain@tharapita.com
http://www.tharapita.com/
Mobile: +372 53 410 610