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.
i.e.
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
