I have a simple member list database that users enter membership info via a form. The problem is, some users after making an entry mistake, instead of EDITING the record they just created, re-join the list using a different username(PHP doesn't allow duplicate usernames) but their other info is the same, ie First Name, Last Name, etc. So now I have duplicate entries for the same user, HOW do I query for duplicate entries in the db? Once I have the list of duplicate records I can delete according to ID Numbers.
Thanks!
Bill
