[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!
d
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


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 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