Jump to content


Photo

Database cleanup


  • Please log in to reply
No replies to this topic

#1 Cmos

Cmos
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 26 July 2003 - 12:32 AM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users