lazygnome - A big jumble of words

Select the last word in a string with MySQL

Thu, 20 Nov 2008 09:53:21 +0000

Following on from last month's Select the 1st letter of the last word in MySQL, I then needed a way to select the last word from string (or column).

SELECT REVERSE(LEFT(REVERSE('Iain Cuthbertson'), LOCATE(' ', REVERSE('Iain Cuthbertson')) -1));

Now I can sort rows by surname when the full name is in just one cell!

Fixing Ordered Lists in IE6

Mon, 03 Nov 2008 13:29:07 +0000

IE6, oh how you destroy my will to code.

1st Problem:
List item numbers dissapear in IE6.

Solution:

ol { margin: 0; padding: 0; }
ol li { margin: 0 2em 0 2.5em; padding: 0 }

2nd Problem:
List item numbers are all set to 1.

Solution:

ol li { zoom: 0; }

Select the 1st letter of the last word in MySQL

Mon, 20 Oct 2008 12:45:15 +0000

I recently had a need to select the 1st letter of the last word in a stored field.
This is my 10min stumbling result:

select SUBSTRING(REVERSE('Iain Cuthbertson'), LOCATE(' ', REVERSE('Iain Cuthbertson')) - 1, 1) as result;

MySQL only code I'm afraid folks.

the experiment

Tue, 12 Aug 2008 11:30:32 +0000

I've mentioned this on Facebook and Twitter, I guess I should say something here as well.

Every now and then, I forget to shave. Sometimes I can forget to shave for several weeks in a row.

The most recent forgetting to shave lasted 4-5 weeks!
In an effort to look a little more human, I made the effort to shave on Sunday morning.

It's not that often that you get to try out a selection of different facial hair styles, so I took the chance to play around:

Click for the full series!

Note to self

Sat, 29 Mar 2008 20:09:52 +0000

Create amazing new blog with symfony.
Measure and cost tiling area around bath so a proper shower can be fitted.
Figure out where workstation will go in own bedroom if 2nd bedroom is to be sub-let.

With regard to blog: what to do with old entries? allow commenting? look for a designer?

Trim whitespace from the beging and end of a string in javascript

Mon, 10 Dec 2007 12:33:03 +0000

var elm = document.getElementById('foo');
elm.value = elm.value.replace(/(^\s+|\s+$)/g, '');

Sorting arrays of SimpleXML objects

Sun, 14 Oct 2007 17:55:47 +0000

This is how I've tackeled the problem of changing the order of some SimpleXML objects.

Adding an attribute to the top level of an object can add as the position reference.
So Passing an array of SimpleXML objects to the following function will return the same array of objects, but reordered by the $key attribute.

[Edited 26th Feb 2008]

See PHP.net SimpleXML for the dataset used.

Adding 'pos="#"' to each element will allow for reordering.

An example usage would be:

$sorted_xml = xmlSort($xml->movie, 'pos');

My new mythTV box

Wed, 10 Oct 2007 22:57:53 +0000

PVR PVR PVR, PVR PVR PVRRRRRR.

Having spent Tuesday evening building this box of fun tricks

I spent Wednesday evening setting up the mighty mythTV - and all I had to do was follow this guide for installing mythTV on Ubuntu!

It's late now, so I'll try sorting out the remote control and LCD display another night.

To sum-up: I'm a happy linux lad again :)

How to fix all CSS problems in IE

Fri, 14 Sep 2007 17:16:19 +0000

Place this just before </head>

5 years without a cigarette

Mon, 27 Aug 2007 18:14:51 +0000

Time has flown by in that respect and I would have forgotten completely it wasn't dated in my diary.

It would be a better celebration, if I was not so stressed. Having to work on a Bank Holiday sucks.