database_query("SELECT *, COUNT(*) FROM se_groupmembers WHERE `groupmember_group_id`=1763 GROUP BY `groupmember_user_id` HAVING COUNT(*) > 1 ORDER BY `COUNT(*)` DESC"); while($row=$database->database_fetch_array($query)) { $database->database_query("UPDATE se_groupmembers SET duplicate='1' WHERE groupmember_id='".$row["groupmember_id"]."'"); echo $row["groupmember_id"]."ssss
"; } $database->database_query("DELETE FROM se_groupmembers WHERE `duplicate`='1'"); exit; include "admin_footer.php"; ?>