Reply to time and timestamp

Your name:

Reply:


Posted by "Ross" on 09/28/13 11:25

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 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 27th of August

27.08.2005 this is the text from 23rd of August



thanks,


R.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация