Sorting results

[zzz]

I have a list of article titles that is built dynamically. I wanted to sort it by page numbers in di something like:

ORDER BY page_number

The problem is that some pages begin with digits, 2, 4, 55, 76 etc. and some begin with letters, like: i21, E13 .

How do I sort it properly?

[LordShryku]

With php, you can use [man]natsort[/man]

[zzz]

This seem like a great solution.

My question, however is: if I have many results, won't it slowdown loading my page by first loading all results into an array and then displaying the results?

So far my results are OK except I woud probably want to move the ones starting with the letter in front of the digit ones...