ASC / DESC

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
SidewinderX
Forum Contributor
Posts: 407
Joined: Fri Jul 16, 2004 9:04 pm
Location: NY

ASC / DESC

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
SidewinderX
Forum Contributor
Posts: 407
Joined: Fri Jul 16, 2004 9:04 pm
Location: NY

Post by SidewinderX »

aw shucks, i was so used to posting in the php forum i forgot about the others :?
Post Reply