Ah, yeah. Unfortunately when we sort by strings/text rather than numbers, computers regard "10" to be lower than "2" (although some programs such as Windows Explorer can detect numbers in strings and sort correctly).
We do have natural sorting functions (natsort() in PHP) to do this, but MySQL ORDER BY doesn't support it so I guess we'll have to perform an extra sorting step within PHP. It should be doable.
|