Jump to content

Database cleanup


Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/784-database-cleanup/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.