Re: [PHP] php/MYSQL remove duplicate records

2004-09-14 Thread Jason Davidson
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

[PHP] php/MYSQL remove duplicate records

2004-09-14 Thread Dustin Krysak
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