Creating an App from Scratch Part 7

Creating a Web App from Scratch Part 7
Where We're At

Now that we've got a set of AJAX controls mostly assembled, we can start building our PHP class to handle list interactions. This class will be called ColoredListsItems and it will reside in the file class.lists.inc.php in the inc folder.
read more

Creating an App from Scratch Part 5

Creating a Web App from Scratch Part 5
Where Are We?

Now that we have a workflow put together and the HTML and CSS to make it look good, we can actually start building the classes that will run this puppy.

We'll focus this installment of the series on the user's account interactions... read more

Creating an App from Scratch Part 2

Creating a Web 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

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