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