ram4nd Posted July 15, 2009 Share Posted July 15, 2009 How can i do order by date the right way with this: 'SELECT * FROM links WHERE active = 1 AND subcat = '.$x.' ORDER BY date ASC LIMIT 0,10' Quote Link to comment https://forums.phpfreaks.com/topic/166096-solved-order-by-date/ Share on other sites More sharing options...
rhodesa Posted July 15, 2009 Share Posted July 15, 2009 is the column called "date"? don't use a column named date, as it is a reserved word in MySQL...if it MUST be called date though, it would look like: 'SELECT * FROM links WHERE active = 1 AND subcat = '.$x.' ORDER BY `date` ASC LIMIT 0,10' Quote Link to comment https://forums.phpfreaks.com/topic/166096-solved-order-by-date/#findComment-875946 Share on other sites More sharing options...
ram4nd Posted July 15, 2009 Author Share Posted July 15, 2009 thank you, how stupid of me Quote Link to comment https://forums.phpfreaks.com/topic/166096-solved-order-by-date/#findComment-875950 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.