A MySQL Query Optimization Example

You’d think in 2013, query optimization would not be something we have to spend much time worrying about.  But sadly, artificial intelligence has not come up with a solution to save us from this boring discipline. Take for example this query: View the code on Gist. Pretty simple right? The query pulls back the last […]

If you’re the type of person who learns best by seeing code in action, you should look at my sample plugin on GitHub. Call me strange, but I’ve never been a huge fan of the WordPress Settings API.   The sheer fact that a diagram like this might be necessary to explain it is indicative to […]

Yesterday I gave an example of how to filter the result from get_terms in WordPress to use a natural order, rather than alphanumeric. So, this: Car 1 Car 2 … Car 10 Not this: Car 1 Car 10 Car 2 … and so on Today, I’m going to show you how to add a new […]

Inevitably, the standard alphabetical sort betrays you.  Say you have a list like this: Car 1 Car 2 Car 3 Car 4 … etc Car 10 Using an ascending alphabetical sort, you’d end up with this sadness: Car 1 Car 10 Car 2 Car 3 Car 4 … and so on If your data is […]

I’ve recently switched to a rather rad workflow involving a local copy of our website run through MAMP using a git repository. We’ve recently started working on a bigger set of changes that require a feature branch. But, these changes also will require WordPress to be upgraded to 3.3, requiring database changes.  Making it impossible […]

HTML e-mails are like wild stallions.  They are really hard to tame. I have been frustrated by the vastly different ways e-mails from my company’s site (http://www.mooreandgiles.com) render in different clients.  After some research, I decided the trick to fix this would be inlining all CSS styles, as various clients will haphazardly abort style blocks you […]