damn dates!

[_0_05_]

alright, i have a mysql table, with a date field - its not specified as date, rather just as a varchar field. I use php's date functions to make the date readable to people, the one i used was

$today = date("d-M-y");

now, I would like to sort the database, by date ascending - how would i go about doing this??

[nnichols]

If you want to store dates in MySQL use a DATE format. Then you can use MySQL's DATE_FORMAT to return the date in any format you want. This way it is easy to sort by the date field.