Cmos

I have a database/table that has 1 field \'name\' I want the names to be unique, the table has a bunch of Duplicate entries in that the names are the same but there is a space ( or some other hidden char) after some so they seem to look different to the table. What I am attempting to do is read the field and use [php:1:9a72f530ce]<?php $curname = trim($row_emails[\'name\']) ?>[/php:1:9a72f530ce] to strip any possible spaces, tabs etc.. and store them in the variable $curname to move them to another table. The problem I am having is INSERTING them to an identical (Empty) table, how would I go about this? SO that I can read from one table and insert into the other, I also need to IGNORE Dups so that each entry in UNIQUE on the second table.

I have a database/table that has 1 field \'name\' I want the names to be unique, the table has a bunch of Duplicate entries in that the names are the same but there is a space ( or some other hidden char) after some so they seem to look different to the table. What I am attempting to do is read the field and use $curname = trim($row_emails[\'name\']) to strip any possible spaces, tabs etc.. and store them in the variable $curname to move them to another table. The problem I am having is INSERTING them to an identical (Empty) table, how would I go about this?