$sql = "SELECT * FROM articles ORDER BY STR_TO_DATE(time, '%d/%m/%y') DESC";
its giving me in ascending order anyway, help please!
thanks =)
Kirix Support Forums
Mysql issues with DESC and ASC?
2 posts
• Page 1 of 1
- terenkleo
- Registered User
- Posts: 1
- Joined: Sun Feb 19, 2012 10:40 am
Re: Mysql issues with DESC and ASC?
It shouldn't be. Our code pretty much passes through whatever mysql is returning, so I'd suggest checking out your query in a test environment or at the mysql prompt. Does the problem happen at the prompt by not in Strata?
Best,
Ben
Best,
Ben
Ben Williams
Kirix Support Team
Kirix Support Team
-
Ben - Kirix Support Team
- Posts: 525
- Joined: Mon Dec 19, 2005 6:29 am
2 posts
· Page 1 of 1
Return to Bug Reports & Suggestions