Jump to content

Archived

This topic is now archived and is closed to further replies.

StirCrazy

identical sql records

Recommended Posts

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 users

Can anyone help?

Share this post


Link to post
Share on other sites
To give an idea of the scope of the problem, does this database have 10 records or 10 million records .. or something in between.

Share this post


Link to post
Share on other sites
Thanks AndyB,

It's relatively small; about 9000 members (guessing about 2000 duplicates).

S.C>

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.