find (matching) person in other table



hi,
the code I'm working on has to compare entered info from registration form with data in members table and list to administrator (my client) all "matching" people. admin then has to decide is person who registered already in database and assign his/her member_id or the registered person is new one and assign new member_id.

I was thinking to assign points (percentage) to matching fields (last name, first name, email, phone, city, zip, phone) and then list people with more than 50%. e.g., if first and last name match - 75%, if only email match - 85%, if first name, last name and email match - 100%, if last name and phone match - 50%... etc.

does anybody have any experience with such a problem? or something similar?

thanks for any help.

-afan
.



Relevant Pages

  • Re: [PHP] find (matching) person in other table
    ... form with data in members table and list to administrator (my client) ... I was thinking to assign points to matching fields (last ... perfect, no mater how much you tweak it -- I mean, let the admin also ...
    (php.general)
  • Re: [PHP] find (matching) person in other table
    ... form with data in members table and list to administrator ... I was thinking to assign points to matching fields (last ... last name and phone match - 50%... ... I've played this game several times. ...
    (php.general)
  • Re: Java RMI JDK1.6 Exception - More Info
    ... I've included the stack trace of the client ... & server. ... I made a minimal example matching your code, ...
    (comp.unix.bsd.freebsd.misc)
  • Re: infinity
    ... the relative sizes of sets are compared by matching ... If all of the members in set A can be matched with a member in ... unmatched members in B (regardless of which matching scheme ... This kind of set comparison works on finite as well as infinite sets. ...
    (sci.math)
  • Re: infinity
    ... the relative sizes of sets are compared by matching ... If all of the members in set A can be matched with a member in ... unmatched members in B (regardless of which matching scheme ... This kind of set comparison works on finite as well as infinite sets. ...
    (sci.math)