[SOLVED] Ordering problem

[waynew]

I have a table for cranes etc that the user can enter in and then have them display in of their lifting capacity (largest first).

 

Please note that the column capacity is of type text.

 

SELECT * FROM crane WHERE type_id = '$type_id' ORDER BY capacity LIMIT $rows, $offset

 

Problem can be seen here:

See here

[waynew]

Ok I know the problem. It's obviously because I used a TEXT column etc. Meaning its not ordering by numbers, its ordering by the aplahebtical position of number. Surprised I didn't catch onto that before.