first used the sql..
Code: Select all
SELECT COUNT(t1.ID) AS siblings FROM table t1 NATURAL LEFT JOIN table t2 GROUP BY t1.ID HAVING siblings > 1Code: Select all
$x = 0;
foreach($dupes as $id) {
$sql = "DELETE FROM table WHERE ID = $id LIMIT 1";
if(mysql_query($sql)) {
$x++;
}
}
echo "$x duplicates deleted";Thanks for your help all!
Will