Kirix Support Forums

Mysql issues with DESC and ASC?

Please let us know if you are encountering problems with the beta or have ideas for how it can be improved. Please provide as much detail as possible so we can try to repeat the problem. Thanks!

Mysql issues with DESC and ASC?

Postby terenkleo on Sun Feb 19, 2012 11:08 am

$sql = "SELECT * FROM articles ORDER BY STR_TO_DATE(time, '%d/%m/%y') DESC";

its giving me in ascending order anyway, help please!

thanks =)
terenkleo
Registered User
 
Posts: 1
Joined: Sun Feb 19, 2012 10:40 am

Re: Mysql issues with DESC and ASC?

Postby Ben on Sat Feb 25, 2012 3:33 pm

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
Ben Williams
Kirix Support Team
User avatar
Ben
Kirix Support Team
 
Posts: 525
Joined: Mon Dec 19, 2005 6:29 am

Return to Bug Reports & Suggestions