> 2005-08-30 13:50.05 "this is the text content"
 
> (i) sort the returned rows in order (latest first)

http://dev.mysql.com/doc/mysql/en/sorting-rows.html

> (ii) be able to extract the individual parts of the date and display them in
> UK format (ddmmyyyy)

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to