ORDER BY numbers in mysql query *SOLVED*

[sanfly]

I have the following query

[code]$r2 = mysql_query("SELECT * FROM album_tracks WHERE at_album = '$aId' ORDER BY at_order") or die(mysql_error());[/code]

at_order is a number, and there are 10 rows. When the results are listed, they come in the following order: 1, 10, 2, 3, 4 etc....

How do I get the numbers to list properly? ie: 1, 2, 3, 4 ..... 10

[phpvolution]

[code]
$r2 = mysql_query("SELECT * FROM album_tracks WHERE at_album = '$aId' ORDER BY at_order ASC") or die(mysql_error());
[/code]

ASC or DESC, I forget which way each goes =P

[sanfly]

Thanks for the help but 10 is still in the wrong place :(

[phpvolution]

Check your DB structure, those numbers could be stored as characters or text, that's usually the case because it looks like it's sorting that way. Make sure they are stored as integers.

[sanfly]

Sweet, that did the trick.

Cheers :)