dig412 Posted March 8, 2006 Share Posted March 8, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/4476-mysql-sort/ Share on other sites More sharing options...
Barand Posted March 8, 2006 Share Posted March 8, 2006 As your scores are numbers, store them as numeric type (INT) and not as char type Quote Link to comment https://forums.phpfreaks.com/topic/4476-mysql-sort/#findComment-15588 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.