Author Archives: Sean Murphy

Making Campfire Work for Me (and More Like IRC)

One of the companies I work with has decided to use the 37signals line of products for internal project management and communication (which I think is great BTW). This means that I sit in a Campfire chat room for working hours of my day, along with a handful of other developers. I started to run into a problem, though, when I didn’t need to be talking with others.

Negative Word Matching with Regular Expressions

Today on the #codeigniter IRC channel someone asked about how to match a string that didn’t start with a specific word using a regex. I quickly threw out that, off the top of my head, /^(abc){0}/ should work. Well, surprisingly, it didn’t. Turns out negatively matching words with regular expressions is a little more difficult. [...]

MySQL SELECT Entries Before NOW()

I’m in the business of making things faster. Using NOW() in a SQL query is something I’m going to complain about. Here’s a familiar senario from the online publishing industry where future dating articles is a commonality:
You have a news site. You need to display only articles that have been published, and one of the [...]

-->