Blog Posts

LEN in MySQL

February 1, 2012

• My SQL

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

Remove all linebreaks in PHP

January 30, 2012

• Php

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!

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

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.

MySQL Error: Can’t get hostname for your address

December 14, 2011

• My SQL

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.

Adobe drops flash for mobiles!

November 9, 2011

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

jQuery Colorbox not showing but background shows

November 8, 2011

• Javascript

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!

Get Value of Checkbox using jQuery

October 25, 2011

• Javascript

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

Everybody’s a web host

September 28, 2011

• Hosting

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

CSS Background Default

September 15, 2011

• Css

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

Restrict PHPMyAdmin to IP Address

August 22, 2011

• Php

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

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

Image corrupt or truncated: “unknown”

July 13, 2011

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

WordPress wp-admin use different language for user

July 7, 2011

• Php

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.

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

May 29, 2011

• Php

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:

Using PHP to validate an IP address

May 18, 2011

• Php

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

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

May 13, 2011

• Php

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.

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

May 9, 2011

• My SQL

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:

What is 1e100.net?

May 5, 2011

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

Hide all error messages PHP

April 28, 2011

• Php

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