Page 1 of 1

ASC / DESC

Posted: Fri Aug 11, 2006 4:29 pm
by SidewinderX
ok so im sorting the column (Exp. Points) by Ascending order using the ORDER BY ASC in the mysql query, but it dosnt sort properly
# Player Exp. Points Kills Headshots PSP Takes Min Pld Med Saves Dbl Kills Deaths
1 AlucardX 52147 7649 1613 103 5110 878 64 7874
2 BOOT 766643 323186 157200 2388 111505 31235 450 187183
3 Ozymandias. 91658 9738 3664 213 6227 1004 47 8689
would this be because they are stored as varchar and not int?

Posted: Fri Aug 11, 2006 4:49 pm
by feyd
SidewinderX wrote:would this be because they are stored as varchar and not int?
Bingo.

..and come on now.. SQL questions are not PHP questions. :arrow: Databases.

Posted: Fri Aug 11, 2006 5:14 pm
by SidewinderX
aw shucks, i was so used to posting in the php forum i forgot about the others :?