Urgent! how can i delete duplicate records from users table

irandoct · Hangin' Around Joined: Dec 01, 2003 Posts: 39

hello all,
i have merged my english and farsi web site . I need to delete some duplicate users from user table. a quick code need for this purpose !
Thanks

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

i doubt if theres an easy way to do this,specially because they all have their ID's.
i dont know how many members you have but if go to the table and let phpmyadmin show them all the you just have to is select on name and after that select the duplicates and delete...

Mesum · Useless Joined: Aug 23, 2002 Posts: 213 Location: Chicago

But still, wouldn't userid will cause the problem too?
Site A has UserA as ID 4 and site B had UserY, then what?

I think he'll have to manually import the users to DB.

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

probably....
i had my share of handywork so if you put your mind to it you can do it all by hand.
just resume from the last added member...so if the last member and id was 250 just pick the first from the farsi nuke_users and give it 251.
im sure its possible to put a script together but if it was easy it was already posted.......i think.