Order Dates from MySQL

[dakey]

Hello,

I am trying to order my results from my MySQL database in date order using the usual way:

$sql = "select * from $table ORDER BY 'date_added'";

This was working fine until it changed to a new month and now it's not ordering them in the correct order. ie anything with this months date is now appearing at the bottom when it should be most recent at the top of the results.

My date is stored as a Text filed in MySQL in the format YYYY-MM-DD

anyhelp greatly appreciated,

thanks.

[devinemke]

dakey wrote:

My date is stored as a Text filed in MySQL in the format YYYY-MM-DD

that's your problem. don't store dates as text, store dates as dates. read up on mySQL's Date and Time Types