Order By

PHP: Select all

$query1 = "select * from site_textblocks where text_pid = '3617' ORDER BY headline ASC"; 

How come when my results sort they do so in this fashion.

1
2
25
3
4
41
5

?

because, a computer thinks that is the proper order.

Computers put things in order by the first # and then the 2nd number etc etc. Best way to do this is to put your results into an array and then sort them using sort(array, sort type)
here is a link explaining this: http://www.w3schools.com/php/func_array_sort.asp

You are trying to sort a string field that contains numbers, which means mysql is reading them as text. (In text, 100 comes before 11 for the same reason baa comes before bb.) If you don't want to change the column type, you can convert it to numbers by using

Code: Select all

ORDER BY (headline+0)

This works for me, YMMV.

If you have mixed text and numbers in the field, afaik you're screwed. My solution would be to create a separate varchar field for ordering. Somebody else might have a better solution.

This thread belongs in the MYSQL forum.