Creating an App from Scratch Part 3

Developing a Workflow

We have a great start going on our list application at this point. The "big idea" is in place, we know how we want the lists to be displayed and interacted with, and we have some back-end structure in place to deal... read more

Creating an App from Scratch Part 2

Where We're At

Up to this point, we've planned the way our app is going to look, as well as given ourselves a basic idea of how the app is going to function. The next step is to figure out what's going to happen behind... read more

Win a Copy of PHP for Absolute Beginners!

For anyone who might be interested in getting their hands on a copy of PHP for Absolute Beginners, there's a giveaway going on over at Brenelz Web Development.

Three copies are available, so head over to the site and get contest details.

And I know I've been neglecting my blog. However, I'm working on an eight-part series with Chris Coyier right now that should kick off very soon, which covers the development of a PHP/AJAX application from concept to completion. Sorry for the delay, but this series should make up for it.

A big thank you to anyone who has already purchased my book! If you've read it and have a minute, I (and my publishers) would really appreciate you taking a moment to review it on Amazon. Thank you again!
read more

Natural Sorting in MySQL

Working Around MySQL's Lack of Built-In Support for Natural Sorting

Several times in the last few projects I've built, I've come across the need to sort alphanumeric rows in a database by number (i.e. entry1, entry2, entry3, etc.). If you've ever tried to do this, you know that sorting entries that are alphanumeric is a pain.

The Data

For our purposes, we'll be using the following table:

Table: sorting_test +--------------------------+-------------+ | alphanumeric VARCHAR(75) | integer INT | +--------------------------+-------------+ | test1 | 1 | | test2 | 2 ... read more

• «
• ‹
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• ›
• »