I learned a ton by reading this tutorial. See if it helps...
"Joshua E Minnie" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hey all,
> I am looking for a way to search a MySQL DB based on a users input
> string. The string would be searched on particular fields in my DB, which
> is already setup. The problem I am having is that I want to be able to
> return strings that match all *or* part of their string. Right now it only
> returns exact (case-insensitive) matches. But I want to be able to return
> partial matches as well. I have the relevancy calculation worked out but
> I'm not sure how to go about gathering the partial matches.
> User inputs: Christmas
> Output would be something like:
> Christmas (100%)
> Christian (67%)
> Christy (67%)
> Chandelier (20%)
> Anything below 10% will not be displayed. I am using a class I found at
> phpclasses.org called better_field_search. I am looking to modify it to fit
> my needs but I'm not sure how to go about it. If anyone has done anything
> similar, I would greatly appreciate any help or direction provided.
> Joshua E Minnie
> Advantage Computer Services, LLC
> Senior Project Manager
> [EMAIL PROTECTED]
> Phone: 269.276.9690
> Fax: 269.342.8750
> "Don't work for recognition, but always do work worthy of recognition."
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php