PHP sorting numbers....

[defuzz]

hello, proably quite simple but hope you can help with out too much ridicule.....

I am doing a php/mysql query that returns a column of numbers ordered by their id. At the moment it is sorting it numerically but is sorting it like this:

1
11
12
15
19
2
20
21
22
23
27
3
30
31
4
5
6


but I want 1,2,3,4,5,6,7,8,9,10,11 etc etc

what am I doing wrong?

[Musicman]

Hi,

if it is mysql sorting them with an order by, you probably have declared the id as a text rather than numeric column.
If you are sorting in php, try
sort($array, SORT_NUMERIC)

at least this is what I get from RTFM ...

Musicman

[defuzz]

hmm, I've already set ID to be "int" but it makes no difference.

I probably AM asking for trouble having a footer like that aren't i.

[Musicman]

Hi,

honestly - it just seems to work everywhere else. You are sure that you ORDER BY id ?

Musicman