Cmos Posted July 26, 2003 Share Posted July 26, 2003 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? Quote Link to comment https://forums.phpfreaks.com/topic/784-database-cleanup/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.