remove duplicate snippet question

[bass123]

Hi,
Found this snippet on the site:
http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=348

Says that it can be changed easily to remove duplicates, I dont know how. Any help is welcome!

I am new to php so please tell me exactly what to do and how please...

I want to keep one record and remove all the duplicates.

Regards and thanks

[tomhath]

The easiest way to get rid of duplicates:

1) Back up the database, just in case

2) Create another table with the same fields as the one that has the duplicates

3) SELECT DISTINCT from the old table into the new table

4) Make sure the new table has what you want

5) TRUNCATE the old table

6) SELECT from the new table into the old one

[bass123]

Thanks for the suggestion, but i really need a script for it like this one. My customer imports a csv file in mysql by a simple script. As he is non technical I need a script to remove duplicates in one click.

Any suggestions on how to modify the snippet?

Thanks!