maxudaskin Posted October 12, 2007 Share Posted October 12, 2007 When I do this, 9 gets counted higher than 10-89, 99 gets counted as higher than 100-998... So I ask for it to be sorted by appid which goes 1 2 3 4 5 ect... but when I got to 100, it counted 100 as 10 with a zero at the end, not 100... so it is sorting by digit one, then digit two then digit three ect... How can I make it sort the numbers as a whole rather than each inidvidual digit? Link to comment https://forums.phpfreaks.com/topic/72983-solved-order-by-something-desc-problem/ Share on other sites More sharing options...
MmmVomit Posted October 12, 2007 Share Posted October 12, 2007 That field is probably a text field, so it's being sorted alphabetically. You need to change it to an integer field. Link to comment https://forums.phpfreaks.com/topic/72983-solved-order-by-something-desc-problem/#findComment-368045 Share on other sites More sharing options...
maxudaskin Posted October 12, 2007 Author Share Posted October 12, 2007 Thanks Link to comment https://forums.phpfreaks.com/topic/72983-solved-order-by-something-desc-problem/#findComment-368049 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.