Order the date by 21 Sept , 18 Sept

[Anon]

how to order this data in the table
21 Sept 2001
18 Sept 2001
29 Sept 2001

into
18 Sept 2001
21 Sept 2001
29 Sept 2001

how to order this date, your help will be appreciate

[matto]

mhm...

php-side ordering:
read out the records, in a loop replace month abbreviations like "Sept" by their equivalent numbers ("09"), then order using some array sort function.

however there surely are quicker ways, if performance is a point.

[hometoast]

http://php.net/manual/en/function.strtotime.php

use the date functions to convert them to 'real' date values. then sort the array.