Re: [PHP] time and timestamp

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 i

RE: [PHP] time and timestamp

[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) (ii) be able to extract the individual parts of the date and display them in UK format 30.08.2005 this is the text from 30th of August 27.08.2005 this is the text from

[PHP] time and timestamp

Hi, I have a row in myslq database called time and is just a simple timestamp column When I echo it out echo $row['time']; echo $row['content']; I get the following 2005-08-30 13:50.05 "this is the text content" Now I am not worried about the time but I would like to know how to (i) sort t