Jay Blanchard wrote:
[snip]
Now I am not worried about the time but I would like to know how to
(i) sort the returned rows in order (latest first)
add ORDER BY `yourdatefield` DESC to your SQL
(ii) be able to extract the individual parts of the date and display
them in
UK format
Have no idea what is 'UK format'. But you can use the DATE_FORMAT MySQL
function to do the same
DATE_FORMAT(`yourdatefield`, '%m.%d.%Y') as `date_formatted` [...]
Also, http://php.net/date
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
