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? 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. 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" 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... Link to comment https://forums.phpfreaks.com/topic/150002-solved-query-order-by/#findComment-787897 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.