richiec Posted April 18, 2009 Share Posted April 18, 2009 Ok heres the issue, i have a field with a number in it, Now numbers go... 1 2 3 4 5 6 7 8 9 10 11 12..... however for some reason it when i use ordder by (number) desc for example.. it will come out as.. 9 8 7 6 5 4 3 2 1 10 11 12 ect should be 12 11 10 9 8 7 6 5 4 3 2 1 The reason for this i know is the first number because its "1" but is there anyway to make them order is exact number order... Thanks Link to comment https://forums.phpfreaks.com/topic/154658-solved-not-sure-what-to-put-as-title-but-11-comes-after-1/ Share on other sites More sharing options...
premiso Posted April 18, 2009 Share Posted April 18, 2009 What type is the numberfield being stored as. My bet is it is stored as varchar and no an INT like it should be. Link to comment https://forums.phpfreaks.com/topic/154658-solved-not-sure-what-to-put-as-title-but-11-comes-after-1/#findComment-813282 Share on other sites More sharing options...
richiec Posted April 18, 2009 Author Share Posted April 18, 2009 lol that worked, duh me such a simple fix hah Thanks mate Link to comment https://forums.phpfreaks.com/topic/154658-solved-not-sure-what-to-put-as-title-but-11-comes-after-1/#findComment-813284 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.