Adsense Junkies get another way to stay in touch

So you probably log in to your AdSense stats once each morning, and then in the evening… and several times during the day. Oh, and you’ve got the FireFox extension that permanently displays your earnings proudly at the bottom of your browser window. But now there’s another way provided by Google themselves to keep an eye on your earnings.

Yesterday Google announced that you can get emailed your AdSense reports on a daily, weekly or monthly basis. It’s not in a nicely formatted email, but a zipped up CSV file to import into your favourite analysis tool or spreadsheet.

It took me a while to work out how to set it up, but once I did it was simple. First you need to create and save a custom report from within your AdSense account. Then visit the Report Manager section of the site and all will become clear.

Voila!

This is a repost of an article I originally wrote for ThirdSquare

Here’s a Sawyer, there’s a Sawyer, and another little Sawyer

We love it… it’s the sort of thing I’d wish I’d be able to do if I had flash, but would sit there devoid of inspiration and talent. It’s The Sawyer Song

(I think these Lyrics are correct…)

Here’s a Sawyer, there’s a Sawyer, and another little Sawyer,
Fuzzy Sawyer, funny Sawyer, Sawyer Sawyer, Locke.
Sawyer Sawyer, golf club, Sawyer, handcuff, Jin, Danielle, Sawyer,
Sawyer Sawyer, Pilot, Sawyer, Sawyer Sawyer Locke.

I was once an airplane, I lived in a cave, but I never saw the way, Alex is my slave.
I was not yet three years dead, but I haunted Jack,
And now listen little child, to the man on crack.

Did you ever see a Sawyer, kiss a Sawyer, on a Sawyer,
Sawyer’s Sawyer, tastes like Sawyer,
Sawyer Sawyer, Locke. Sawyer, Sawyer, Locke!

Half a Sawyer, twice the Sawyer,
Not a Sawyer, Lawyer, Sawyer,
Sawyer in a bar, I saw a Sawyer,
Sawyer, Locke.

Is that how it’s told now, is it very late,
Is it made of aloe juice?, Sayid, Michael, Kate.
Now my song is running thin, I’ve run out of stock,
time for me to retire now, and become John Locke.

Can Windows XP write DVDs?

I’ve had this PC for about a year now and never once tried to use the DVD burner, so it was with disapointment I found that I couldn’t drag files to the DVD drive like I can when I want to burn a CD-ROM. I thought I must just have a duff disc, but after buying some more I found they didn’t work either!

A quick search online revealing an article on Microsoft’s site that says try “Sonic DVDit!, neoDVD, or one of ULead’s DVD products”. That’s odd, I thought, perhaps my drive came with some software and following a swift slap to the forehead I find that I’ve got CDBurnerXP Pro 3 installed already. It’s free to download and works well.

Um, and that as they say, is that…

MySql’s last_insert_id always returns 0

“Aaaaagh!”, I was heard to scream several times. Why won’t the damn thing return the last id. I’m doing exactly as I’ve done a million times before, yet it aways returns a zero. I don’t have to be transaction based to use last_insert_id do I?!? Well, close actually. Not in a transaction, no. But on the same database connection. See, I was issuing an insert command via the phpMyAdmin program, then trying to get the last id in code.

So:

SELECT LAST_INSERT_ID();

…does indeed work. Grrr.

Can’t delete or rename a file on windows?

Me either, happens all the damn time, you get a message like “The process cannot access the file because it is being used by another process”. When you know damn well there’s nothing accessing it. It’s a damn movie file you never even got round to watching from about a year ago.
Continue Reading »