When mysql won't sort correctly 1

[kupe]

Last in, first to appear is the desire. Yet when I call on the database via php, I get post for May 9, May 8, etc, and after that May 24, May 23, May 21. Something’s wrong.

$query = "SELECT PostID, CONCAT(FName, ' ', SName) AS Name, About, Date_Format(DoA, '%b %e') As DoA FROM Post ORDER BY DoA DESC";

 

[azzazzello]

Once you do Date_Format, it becomes a string. And gets evaluated as a string. As far as strings go, "May 8" is greater than "May 24". You, for some reason, are aliasing Date_Format(DoA, '%b %e') as an existing column name DoA. I don't think you should do that. Because then you are no longer have access to the original date field to sort by. Try this

$query = "SELECT  PostID, CONCAT(FName, ' ', SName) AS Name, About, Date_Format(DoA, '%b %e') As DoA1 FROM Post ORDER BY DoA DESC";

That way you sort by the original date string.

 

[kupe]

Of course, azzazzello! Very much obliged to you. Cheers.