PDA

View Full Version : Help with double users


Chris Gwynne
02-01-2004, 04:45 PM
Hey all :)

I need a a script that will show me any users with duplicate email addresses in the database, some of my members cannot login because of this very issue.

It needs to list them as a member search in vB3 would do so I'm able to see it all easily.

Any help is appreciated!

Regards,
Chris

g-force2k2
02-01-2004, 06:22 PM
a-drive,

Perhaps this query will show you the users with duplicate emails?

SELECT COUNT(*) AS dups, userid, username
FROM user
GROUP BY email

Also in vb settings you might want to enable the unique email option.

Cheers,
g-force2k2