Category Archives: Programming

Removing duplicate rows in MySQL (the “easy” way…)

I recently had to sort out a database for a client. It was a mess….

The database was for people to contact, sort of like a telemarketing system (their choice, not mine…). The problem that they were having was that the database contained a lot of entries that had people with different names at the same address with the same phone number. As you can imagine, calling the same people over and over again just because their phone number has come up again was not the best way to make friends.

Continue reading Removing duplicate rows in MySQL (the “easy” way…)

WordPress problems: Cannot Connect To Database

It seems to be that there’s a whole lot of people that are getting this error message when they are trying to install or move their WordPress site. Even though this problem is common and there’s a very simple solution, people seem to always have more trouble with it then it’s worth. Continue reading WordPress problems: Cannot Connect To Database