Posted By

Abe on 01/29/08

Tagged

mysql
database

Versions (?)

Last Edited at 01/29/08 12:10pm

Statistics

Viewed 614 times

Favorited by 3 user(s)

Related snippets

Remove Duplicate Rows

/ Published in: PHP

$duplicates checks and groups duplicated rows with the same field1 and field2 (like comments maybe) and $limit counts how many times a row is duplicated.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
$duplicates = mysql_query("SELECT field1, field2, count(*) FROM table GROUP BY field1, field2 having count(*) > 1");
$count = mysql_num_rows($duplicates);
if ($count > 0) {
	while ($row = mysql_fetch_assoc($duplicates)) {
		$field = $row["field1"];
		$limit = $row["count(*)"] - 1;
		mysql_query("DELETE FROM table WHERE field1='$field' LIMIT $limit");
	}
	mysql_free_result($duplicates);
}
?>