Blog

Filtering Tables in Joins in MySQL
03 December 2007
I had a situation recently where I was outer joining one table onto another. I needed all rows from the first table, plus any matching rows from the second table. So:
```
SELECT *
FROM table1 t1
LEFT JOIN table2 t2 ON (t1.col_a = t2.col_a)
```
So far, so good, right? In …
Read more

PHPWomen Podcast
29 November 2007

I'm wildly excited about a virtual event scheduled for next week, its the PHPWomen PHP|Abstract. Some of the main members, Elizabeth, Elizabeth, Ligaya and Sara are all going to chat with Cal Evans about the group, with live participation on IRC.

Actually I wonder if Cal knows what he …
Read more

Happy Half House-Year
25 November 2007

Today marks six months since we picked up the keys to our first home, a lot has happened! I thought this anniversary (is it strictly an anniversary, if its less than a year?) would be a good time to have a quick recap on what's been going on here.

The …
Read more

IPC Report on PHPWomen
21 November 2007

I was asked by the phpwomen group before I went to IPC whether I would do them a write-up when I got back. I agreed and its online: http://www.phpwomen.org/wordpress/2007/11/21/ipc-report/.

There is even a a photo of me - thanks Sebastian :)

Read more

BarCampLeeds Recap
18 November 2007

I did it! I went and spoke at BarCampLeeds, there's flickr evidence to prove it as well :)

My talk was "Source Control Saves Lives", a primer on what source control and why you should use it, with a definite subversion twist because that's what I know the most about and …
Read more

Thinking of BarCamp Leeds
15 November 2007

Recently I found out about a phenomenon called BarCamp, where a bunch of people, mostly geeks, turn up and run their own un-conference. Every attendee speaks, at least that's the theory, and there are a lot of concurrent sessions - so you just attend what you want to. It looks interesting …
Read more

PDO for PHP on Ubuntu Edgy Eft
14 November 2007

Today I was asked to add PDO support to PHP on our development box, which I thought was running Ubuntu Feisty Fawn. The first problem is that it's not running Feisty Fawn, its running Edgy Eft, which is an older version. The next problem is that the PDO libraries weren't …
Read more

The Tradesman Cometh
13 November 2007

The house, as I may have mentioned, has been in disarray lately. Since buying the place at the end of May we've had the guttering and verge boards replaced, central heating fitted (involving moving the boiler), and the entire house rewired including the bonus addition of smoke detectors, outside lights …
Read more

Haywire Rewire
09 November 2007

I've been away for five days, and got back home yesterday (Thursday) early afternoon, due to work Friday as usual and then head off a weekend away. While we were away the electrician was coming in to rewire our house - an expensive operation but a very much-needed one. The inside …
Read more

No Blogroll
07 November 2007

I've had a few requests recently to exchange links or to add people to my blogroll, its a way of giving a bit of kudos to people that you admire and whose work you read. The thing is, I don't have a blogroll, and if I did I fear it …
Read more

Frankfurt Visit: First Impressions
05 November 2007

I'm in Germany for a few days at the IPC and since we had some time spare I've been exploring!

First of all, we took trip into Frankfurt itself yesterday. The queue for the ticket office was wildly long but some people who had a weekend travel pass and had …
Read more

Scottish Holiday
04 November 2007

Recently we had a week's holiday with the family in Scotland, which was lovely and quite relaxing as we were right out in Dumfries almost in Stranraer and there really isn't a lot to do there! Its beautiful though and we were really lucky with the weather.

We actually took …
Read more

⇦ 72 of 92 ⇨