StirCrazy Posted October 4, 2006 Share Posted October 4, 2006 Hi folks,I've been trying to convert a Mysql database to work from a crappy old script that had a habit of inserting duplicate records.I want a little bit of code that goes through and checks that each email address on each account is unique. If there is more than one account using the same email address I want to:-[code]echo "Email address " . $email . " is associated with account numbers: " . $list_of_accounts_ids;[/code]the records are in:- select id,email from usersCan anyone help? Quote Link to comment Share on other sites More sharing options...
AndyB Posted October 4, 2006 Share Posted October 4, 2006 To give an idea of the scope of the problem, does this database have 10 records or 10 million records .. or something in between. Quote Link to comment Share on other sites More sharing options...
StirCrazy Posted October 4, 2006 Author Share Posted October 4, 2006 Thanks AndyB,It's relatively small; about 9000 members (guessing about 2000 duplicates).S.C> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.