I'm trying to create a call logging system and want to find contacts in
a kind of fuzzy way.
I created a database with client names, their phone numbers and company
I created a script that searches the corresponding database fields for
something "like" the contents of those fields.
the user can type something like
name : johnson
firstname : pete
phone : 67890
company : FastLane
the search does:
select * form contacts where FirstName like $fname or Name like $name or
Phone like $phone or Company like $comp
Now I want get the ones where I have the most "hits" in the multiple
"or" on top.
Do I search in the directions of aliases to do this? Do I need to make a
If anyone has got a sample of a comparable search......