Re: timestamp and php

2005-08-30 Thread Michael Stassen
[EMAIL PROTECTED] wrote: Hi, I have a row in mysql 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

Re: timestamp and php

2005-08-30 Thread Scott Noyes
> 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 (ddmm) http://www.php.net/manual/en/function.

timestamp and php

2005-08-30 Thread ross
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