How to install WordPress 2.5.1

WordPress is a insanely popular blogging platform, and with every release it gets better. It’s also very easy to install, even for those who have never installed a CMS on their server before.
The first step is to head over to WordPress.org and download the WordPress file. Click on the Download button on the [...]

SQL_CALC_FOUND_ROWS - Is it faster?

Reading through a post on SQL_CALC_FOUND_ROWS actually being slower that running one query followed by a count query I decided I needed to do a little benchmarking on my own.

addthis_url = ‘http%3A%2F%2Fforumsblogswikis.com%2F2008%2F06%2F12%2Fsql_calc_found_rows-is-it-faster%2F’;
addthis_title = ‘SQL_CALC_FOUND_ROWS+-+Is+it+faster%3F’;
addthis_pub = ‘RyanNutt’;

Sometimes I just frustrate myself

Have you ever spent way too much time looking for a solution to a problem?  Ever felt like smacking yourself in the head when you finally found the fix?  Well today I spent about half an hour trying to find out why a MySQL INSERT query wasn’t working.
I was working on a logging table [...]

Comparing MySQL search speed for different column types

Starting work on a new website I wanted to know which type of MySQL column was the fastest to search on. I assume it’s a numeric column, but I really want to know how much of a difference it makes. What I’m working on right now is an options table and it would [...]

Using AJAX to get city and state from zip code

This is something that I wrote a few years ago when I first started using AJAX type calls in my programs. It will allow you to enter a zip code, either 5 or 9 digit, and will load the city into a text field and state into a dropdown. If the city field [...]