Re: Mysql search
| From: | Robert Cummings | Date: | Wed, 22 Oct 2008 05:13:15 +0000 |
| Subject: | Re: Mysql search | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-282223@lists.php.net to get a copy of this message | ||
On Tue, 2008-10-21 at 21:48 -0700, Ryan S wrote:
> Hey all,
> I have two columns in my DB
> title varchar(254)
> and
> jtext text
>
> which I would like to search, as the user might enter two or more words I am opting not to use
> LIKE %search_term% so started searching google, I came across this very promising class:
> http://code.activestate.com/recipes/125901/
>
> but when i tried to run it I am just getting a blank page, no errors or anything.
>
> Am hoping someone out there can recommend a better script or maybe share some of your own code?
>
> Any help would be appreciated.
Do it right... read up on MySQL's fulltext matching.
Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP