[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++;
}