Small database maintenance script

I need a script that analyzes the records in my db with a unique identifier. It will then examine a certain field within that group of records and if there is another record with the same thing in that field, it will delete the duplicate record. I need it to send me an email telling me what groups of records had duplication that was removed and what the unique identifier was for each group of records. I will include a zip file with a data sample and complete instructions. My versions are: PHP version: 5.2.5 MySQL version: 5.0.67 ## Deliverables See the attached zip file. It has two documents, a readme and a data sample. Versions: PHP version: 5.2.5 MySQL version: 5.0.67