Iain's nonsensical words

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!

IE6, oh how you destroy my will to code.

1st Problem:
List item numbers dissapear in IE6.

Solution:


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

Solution:

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.

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!

1. Create amazing new blog with symfony.
2. Measure and cost tiling area around bath so a proper shower can be fitted.
3. 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?

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

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');

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

Place this just before </head>

<!--[if IE]><style type="text/css">body { display: none; }</style><![endif]-->

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.