c_shelswell Posted September 11, 2008 Share Posted September 11, 2008 Hi, I'm having a bit of struggle with an order by mysql statement. My query is: select * from news_tours where area='news' order by timestamp limit 0, 3 This works fine and sorts everything if i don't have the limit on there but doesn't sort as expected when it's there. I'm sure this is very simple but if anyone could help that'd be great. Cheers Link to comment https://forums.phpfreaks.com/topic/123738-solved-trouble-with-order-by/ Share on other sites More sharing options...
JasonLewis Posted September 11, 2008 Share Posted September 11, 2008 That query, from looking at it, will order rows starting at 0 with with a length of 3 by timestamp. You can also had ASC or DESC. Link to comment https://forums.phpfreaks.com/topic/123738-solved-trouble-with-order-by/#findComment-638937 Share on other sites More sharing options...
c_shelswell Posted September 11, 2008 Author Share Posted September 11, 2008 I thought it ordered by ASC as default? I followed your advice and added it in and it worked fine though so thanks very much. Link to comment https://forums.phpfreaks.com/topic/123738-solved-trouble-with-order-by/#findComment-638943 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.