Blog Posts

LEN in MySQL

February 1, 2012

In MySQL 5.1 LEN is called LENGTH, you use it exactly the same and pass in the link, so: LENGTH(link).


Read More

Remove all linebreaks in PHP

January 30, 2012

If you are having problems with a string that keeps adding a line break when output from PHP to HTML then the following code will work wonders for you!


Read More

IE9 adding empty table cells in large table

January 24, 2012

Well as usual, we are once again fighting the woes of the beloved Internet Explorer, and it appears that Microsoft’s latest greatest new and improved browser rival to the market IE9 still has a whole bunch of irritations and retardation to worry about (saw that one coming).


Read More

SELECT Duplicate Items Using SQL

December 20, 2011

If you have a table which has duplicate items in then you can use the below statement to select them.


Read More

MySQL Error: Can’t get hostname for your address

December 14, 2011

This error is thrown by MySQL because it tries to do a DNS lookup on the address connecting to the server and it fails due to the IP not being able to be resolved back to a name or some-other deeper DNS bust problem.


Read More

Adobe drops flash for mobiles!

November 9, 2011

..and it’s official – so says Adobe’s blog (read it here).


Read More

jQuery Colorbox not showing but background shows

November 8, 2011

I was using Colorbox for some lightbox type effects to show larger images when clicking on thumbnails, but for some reason the background was showing up but the pretty little box in the middle where the larger image is supposed to show never showed up, so this is how I made it finally appear after many failed attempts!


Read More

Get Value of Checkbox using jQuery

October 25, 2011

This one is quite an easy one, but a good one to mention non-the-less as it does definitely come in really handy.


Read More

Everybody’s a web host

September 28, 2011

To cut straight to the point, “we’re living in the age where everybody’s a web host”.


Read More

CSS Background Default

September 15, 2011

If you would like to override an already attached class containing a background then you can use the following:


Read More

Restrict PHPMyAdmin to IP Address

August 22, 2011

Would you like to restrict PHPMyAdmin from being accessible to the whole world?


Read More

2014 – Commands out of sync; you can’t run this command now

August 4, 2011

#2014 – Commands out of sync; you can’t run this command now


Read More

Image corrupt or truncated: “unknown”

July 13, 2011

What is “Image corrupt or truncated: ” and what does it mean?


Read More

WordPress wp-admin use different language for user

July 7, 2011

I needed to do some work on a WordPress site a little while ago and all the admins were French – and I cannot speak French other than the popular swear words – so had no idea what was going on in the /wp-admin/ so needed some way of enabling my newly created user account to be in english while letting everybody else use french as they had been up til that point.


Read More

Replace all spaces in HTML with   except in HTML tags using PHP

May 29, 2011

If you would like to replace all the spaces in an HTML string with so that you can render it out to the browser but you also want to retain current spaces in HTML tags you can use the below method:


Read More

Using PHP to validate an IP address

May 18, 2011

You can use the PHP code below to check if an IP address is valid or not.


Read More

What is the difference between is_home() and is_front_page()

May 13, 2011

Call me ignorant, or call me an ignorant geek, but I used to think is_home() and is_front_page() was the same thing, until I experimented with them the other day and noticed they did quite different things.


Read More

..near 'option o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.o' at line 1

May 9, 2011

So you’ve just installed Opencart 1.5.0 and when attempting to edit a product or category or etc you get the following error:


Read More

What is 1e100.net?

May 5, 2011

So you are probably reading this because you are not sure what 1e100.


Read More

Hide all error messages PHP

April 28, 2011

PHP Error messages showing up in your web applications are a dangerous thing.


Read More