[seans9]

ok im not that advanced in php...but here is the deal. i have a database with a lot of email addresses (some of which are duplicates). each email address has its own row. what i want to do is go through and delete the rows with duplicate ones (leaving at least one of the email addresses)...i hope that makes sense. this is what i wrote and its not working. PLEASE help. thanks

PHP Code:

$query="SELECT * FROM `emails` ORDER BY `email` ASC LIMIT 0, 30";

mysql_query($query);

$result=mysql_query($query); 



$numrows=mysql_num_rows($result);



$totalemailsdeleted=0;

$i=1;

$i2=0;

while($i2 < $numrows)

{

    $id=mysql_result($result, $i2, id);

    $email=mysql_result($result, $i2, email);

    while($i < $numrows)

    {

        $idcompare=mysql_result($result, $i, id);

        $emailcompare=mysql_result($result, $i, email);

        if($emailcompare == $email)

        {

            $query="DELETE FROM `emails` WHERE `id` = '$idcompare' LIMIT 1";

            mysql_query($query);

            $emailsdeleted.="$emailcompare<br>";

            $totalemailsdeleted++;

            $numrows=mysql_num_rows($result);

        }

        else

        {

        }

        $i++;

    }

    $i2++;

}