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 Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.