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? Link to comment https://forums.phpfreaks.com/topic/22939-identical-sql-records/ 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. Link to comment https://forums.phpfreaks.com/topic/22939-identical-sql-records/#findComment-103517 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> Link to comment https://forums.phpfreaks.com/topic/22939-identical-sql-records/#findComment-103524 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.