Hi, Have a load of dates in the format DD/MM/YY. Thet are stored as a VARCHAR on a mysql DB. I need a way to sort them into order(most recent first) Using the QUERY $query = "SELECT doc_date FROM papers ORDER BY doc_date DESC"; this just arranges them by day. e.g 30/12/2005 30/11/2005 22/12/2005 19/12/2005 17/12/2005 12/12/2005 10/12/2005 06/12/2007 06/09/2002 05/12/2005 05/09/2005 Now I have tried to use strtotime() but I find this needs a timezone (GMT) to work and I don't know if the server supports it. Also I find strototime() and mktime() very confusing and a things go wrong of you work in GMT because we also have Brittish Summer Time where the clocks get put back/forward at certain time of the year. Is there a simple function like sort() that could do it?? R. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
