<?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",$link);
                echo "deleted $row[1]
";
           
}
        echo mysql_error();
    ?>