Mysql issues with DESC and ASC?

[terenkleo]

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

its giving me in ascending order anyway, help please!

thanks =)

[Ben]

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