[RESOLVED] ORDER BY number not working right??

[atokatim]

I have a simple query that is supposed to put the songs in order by the "ord" value....but it is not working right.

order from 1 to 10 comes out like this :
1
10
2
3
4
5
6
7
8
9

here is what i have :

$member_result = mysql_query("SELECT filename, songname, bandname FROM images WHERE mid = '$folder' ORDER BY ord");
while($file = mysql_fetch_assoc($member_result)){

Thanks!

[atokatim]

never mind...i got it. the "ord" table was a varchar instead of INT