Multi Checking

Posted: Sat Mar 22, 2003 9:57 am (21 years, 9 months ago)

I have an online game with user details stored in a database. I want to check for multiple accounts under one email address and delete them as users are only allowed one account on the game. How would I scan the mySQL database looking for more than one occurance of the same email address?

Team Member Joined: 06 Jan 2002 Posts: 2564

Why don't you set the email column as UNIQUE? Wouldn't that be easier?

Also, shouldn't you just stop these users from signing up, instead of deleting them afterwards?

Posted: Sat Mar 22, 2003 1:21 pm (21 years, 9 months ago)

There are reasons I don't want to do it like that, but I won't go into them. Is what I am wanting to do possible?

Posted: Sat Mar 22, 2003 3:36 pm (21 years, 9 months ago)

you could use a while loop to go through all the rows in the table and keep a count of the number of each email address.

WebHelper Joined: 01 Mar 2003 Posts: 69 Location: Texas

Here's what you need to identify email addresses that have been used more than once. Then you can use this list to process your users...

Code:

select user_email, count(*) as email_count
from phpbb_users
group by user_email
having email_count > 1