delete duplicate rows in mysql using php

DrRakha

Code:

<?php

/* Removes duplicate records in a table

Code by:
Bardhyl Fejzullahi
[email protected]
17.09.2008
Pristina, Kosovo

EX.
|id|name|
==========
|1|test|
----------
|2|php|
----------
|3|test|
----------
Result
|id|name|
==========
|1|test|
----------
|2|php|
----------
*/

$cn= mysql_connect("localhost", "root", "") or die('Could not connect');
$db= mysql_select_db(test, $cn) or die('Could not select database');

    $query="SELECT * FROM name";

    $result=mysql_query($query);
    echo mysql_error();

        while($row = mysql_fetch_array($result, MYSQL_BOTH))

        {
                $query1="SELECT * FROM tablename WHERE name = '".$row[1]."'";

                $result1=mysql_query($query1);
                $count = mysql_num_rows($result1) - 1;

                mysql_query("DELETE FROM tablename WHERE name='".$row[1]."' LIMIT $count");
                echo "deleted $row[1] <br>";

}
        echo mysql_error();
    ?>


--
Bardhi

Guest

hi plz define $link variable.

DrRakha

it is a bug , i deleted it.

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

delete duplicate rows in mysql using php

Topic Tags