Sorting Problem

[kenhess]

I am pulling data on servers out of a database and they are sorted by name, but as you can see below, sorting by name does an alphanumeric instead of a natural sort.

How can this be solved?

sibsgp10
sibsgp18
sibsnc07
sibsnc105
sibsnc106
sibsnc11
sibsnc111
sibsnc112
sibsnc13
sibsnc14
sibsnc30
sibsnc41

I am using a select statement as: ORDER BY Name ASC which gives the above list. Is there a way to get them into correct order?

[AstroTeg]

Which database engine you using?

PHP does have some sorting functions (check 'em out on php.net).

The trick is you might be able to do it from the query which would be a bit better (and faster).

[kenhess]

It is MySQL 4.x

I know php has some sorting stuff but was wondering how to implement a sort when I pull the data from the array with mysql_fetch_array

and do a $system = $row["Name"]; for the name pull out of the array.

So, do I sort them correctly with the SQL statement or when I pull the rows from the array and how?