Alex Poole

Pragmatic PHP, MySQL, Marketing & Technology

Alex Poole header image 4

Simon Wilcox - Trumpet

December 14th, 2011 by alex
Respond

This is a personal message to Simon Wilcox, who plays the trumpet. I have no way I know of contacting you any other way Simon, so I figure sooner or later you’ll either Google yourself, or someone else will Google you and pass this message on.

In 1991 / 1992 I rented a room in your house. During that time I treated you absolutely atrociously. With others in the house I bullied you mentally, damaged your personal property and showed a breathtaking lack of respect, kindness and compassion. I was an absolute c**t to you.

I only wanted to say that, when I look back on that time, I’m appalled by how I acted; deeply ashamed of my behaviour. Simon, I’m very very sorry. I can’t imagine quite how I’d make up for it, or that you even give a monkey’s now, 20 years down the line, but if I can ever go some way towards showing you how sorry I am and making good, you can contact me through this site. Anyway, I wish you all the very best.

Just for the sake of this post doing its search engine thing, I’ll reiterate that was a message for a gentleman by the name of Simon Wilcox, a trumpet player. And if you’re not Simon but you know him, please pass on the message.

Thanks. Alex.

Tags:   No Comments.

Ely Dog Walking

October 31st, 2011 by alex
Respond

If you’re looking for someone to walk your dog(s) in or around Ely, click on over to Ely Dog Walking. Karen has started to offer this service, and knowing what a fuss she makes of Cocoa, your dog will be in excellent hands.

karen-cocoa-final_small

We looked long and hard for someone to walk Cocoa on the days we were both working and couldn’t find anyone suitable - most dog walkers are already very busy - so we found a friend to help out and Karen decided to start offering a dog walking service herself. If you prefer, she’ll pop round your house and just make a big fuss of your dog when you’re out. Most people, I’m guessing, would prefer a good walk then a 10 minute fuss at the end. Anyway there you have it -> Dog walking in Ely.

Tags: No Comments.

Don’t trust the Google Keyword Tool for low-volume long-tail

October 11th, 2011 by alex
Respond

I’ve suspected this for a while but I got around to proving it just now. I downloaded the 100 most popular terms for a site of ours. Its a geo-optimised site, so receives traffic for “blue widgets chelmsford”, “blue widgets Birmingham” etc etc. Although I knew - for an absolute fact - that we had a handful of visits every month for each term, when pumped back into the keyword tool a great many came out zero. The takeaway for us is this: build the pages even if the keywords tool says “no” because, regardless of what it has to say, the visitors are in fact there. Not in their millions certainly, but they’re there. Cool. Remember every line in this table has had at least 1 visit in the last month (and our site is top 5, but not necessarily top, for these terms, so realisitically the demand must be in the 10+ range, if not the 50+ range.) There’s more fine-grained traffic there than anyone’s admitting to.

.adwords_inaccurate_example

Tags: No Comments.

Quick moan

September 28th, 2011 by alex
Respond

<rant>This is my blog so I’m allowed the odd moan. I just wanted to say to whomever ran a key down the side of my van on Saturday night in Wilburton, that you’re a nasty little coward. I doubt I’ll ever find out who you are, but you owe me £340. What a truly low thing to do. If you had a problem with me, you could have told me or even picked a fight. I would at least have respected that you looked me in the eye instead of skulking around brandishing a sharp metal object. Karma, my cowardly little friend, is a bitch. Wait for it… </rant> :)

Tags: No Comments.

Check old MOTs and MOT advisories online

May 11th, 2011 by alex
Respond

As long as you have access to the V5 or an MOT certificate, you can check the MOT history of a car back to 2005

Dead handy:

http://www.direct.gov.uk/en/Motoring/OwningAVehicle/Mot/DG_10020539

Original post at http://www.mbclub.co.uk/forums/favourites/43523-look-up-mot-advisory-notices.html

Useful today when the garage who sold me a car with a new MOT “forgot” to include the advisory printout. Turned out to be a windscreen chip and some worn brake pads. I can have a little chat with them about the brake pads now :)

Tags: No Comments.

Domains for sale

May 10th, 2011 by alex
Respond

I’ve just listed the following domains for sale:

affiliateramraid.com

backlink-power.com

best-affiliate-programs.co.uk

buy-windows.co.uk

cbconvert.com

cbpdc.com

cbrampage.com

cdtomp3.co.uk

clusterjobs.co.uk

crm-mail.com

cvrm.co.uk

formcam.com

freescruffys.com

funnyvid.co.uk

get-articles.com

houraday.co.uk

internetmarketingadviser.co.uk

link2profit.co.uk

link2profit.com

linktoprofit.co.uk

listepidemic.com

makemoneyatho.me

motorleads.co.uk

nichedashboard.com

rebrandablereport.com

requestdonation.co.uk

requestdonation.com

ripcd.co.uk

salesvideosecrets.com

tuberaid.com

videofactor.co.uk

web-automation.co.uk

wwwcrm.com

youlaugh.co.uk

If you’re interested in any of them please drop me a mail at alexpoole (at) gmail . com
I’ll consider any sensible offers.
Cheers

Tags: No Comments.

Keyword Multiplier

April 28th, 2011 by alex
Respond

We wanted a tool like the de-duplifier, but that allowed you to input TWO lists of keywords and it multiply them together for seo and local seo purposes. For example, list 1 might be a list of towns in your area, while list 2 might be a list of products you stock.

Here is that tool:

Keyword Multiplier

I hope its useful to you.

Tags:   · · No Comments.

Twitter background image grabber fixed

April 5th, 2011 by alex
Respond

I just noticed Twitter had changed their HTML slightly which broke the Twitter background image grabber, but its fixed now..

Tags:   No Comments.

Add a Close button to a Fancybox window

January 20th, 2011 by alex
Respond

I spent ages digging around for this, and it should be simple!

Actually, it is simple. But only when you know how. This is how you add a close button to the contents of a Fancybox window (ie, the contents inside the iFrame) :

<a  href=”#” onClick=”parent.jQuery.fancybox.close();”>Close This Window</a>

So there you go.

Tags: 12 Comments

Visitation tree method in PHP

October 24th, 2010 by alex
Respond

Using one DB query per node in a tree is expensive, and if your tree is large, will horribly slow the site. The answer is to take a little more time on inserts and reap the efficiency rewards in selects. I’ve been using this technique for a while but I just mislaid my “rebuild tree” method so I was digging around for an example online. This article in Sitepoint by Gijs Van Tulder spells out the techniques and pros & cons nice and clearly, with good solid code examples. They call it the “ modified preorder tree traversal algorithm” but whatever. I’ve always heard it called the Visitation Method. Same thing different name. Cool. Cheers Gijs & Sitepoint.

PS this bit of PEAR code is handy too

Tags:   · No Comments.