you could select out all the DISTINCT email addresses, and delete the table, and repopulate it with your selected rows add a constraint to the table to make email column unique afterwards maybe.
Jason Dustin Krysak <[EMAIL PROTECTED]> wrote: > > Hi there - I have an extremely simple table that has a unique Id and an > email address..... what I am looking for is an example of a PHP script > that will poll the MYSQL database and delete the duplicate records > leaving only 1 unique (email) record. > > can someone point me to the right place? > > thanks! > > d > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php