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…)

Outlook has lost my IMAP folders!

Yes, that’s right. I was just as surprised as you would be too. I started up Outlook to check my emails this morning and I was schocked. my Inbox and Send Messages folders were there, but none of the sub folders that I use were there. What happened to them? Were they deleted? Were they hidden? Did some big alien monster get into my mail server and eat them all? Continue reading Outlook has lost my IMAP folders!

Gmail really does send SPAM!!!

Now I know that I’m probably going to get told off for this, and maybe even have some “official notices”, but I’m going to tell it like I see it.

In the past month I’ve got two things going on. I’ve been planning a wedding, and I’ve been discussing money matters with various parties. All in all, a very standard thing to do. Most of this has taken place through my default email account, that just happens to be GMail.

So, why do I think that that’s lead to me being SPAM’ed by Google? Very easy…

Continue reading Gmail really does send SPAM!!!

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