zeeshan_haider000 Posted March 18, 2009 Share Posted March 18, 2009 Hi, I have this query: "SELECT * FROM table ORDER BY ENum DESC" It was working fine until the # of rows became larger than 100. Now it display the data as 99, 98.....100... I want the data to be displayed as: 100, 99, 98....1 and so on... What am i suppose to do? Quote Link to comment https://forums.phpfreaks.com/topic/150002-solved-query-order-by/ Share on other sites More sharing options...
drisate Posted March 18, 2009 Share Posted March 18, 2009 make sure ENum is set to INT thats all i can think of untile you can give more details. Quote Link to comment https://forums.phpfreaks.com/topic/150002-solved-query-order-by/#findComment-787763 Share on other sites More sharing options...
sasa Posted March 18, 2009 Share Posted March 18, 2009 "SELECT * FROM table ORDER BY ENum+0 DESC" Quote Link to comment https://forums.phpfreaks.com/topic/150002-solved-query-order-by/#findComment-787790 Share on other sites More sharing options...
zeeshan_haider000 Posted March 18, 2009 Author Share Posted March 18, 2009 Thank you guys, problem solved... Quote Link to comment https://forums.phpfreaks.com/topic/150002-solved-query-order-by/#findComment-787897 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.