Jump to content

Archived

This topic is now archived and is closed to further replies.

dig412

mysql sort

Recommended Posts

i'm using this query to retreive scores for a flash game:
[code]SELECT * FROM fennec_game ORDER BY score DESC;[/code]

for some reason, a score of 9 will appear above a score of 89, as single digits are orderd incorectly. is there a way to fix this?
thanks in advance

Share this post


Link to post
Share on other sites
As your scores are numbers, store them as numeric type (INT) and not as char type

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.