MySQL Forums
Forum List  »  Newbie

elasped time between to dates
Posted by: Trudy Nielsen
Date: April 28, 2005 11:01AM

Having an table with a timestamp field. I want to find out how long an item has been posted compared to today's date.

$result=mysql_query("SELECT posted FROM loads ");
while ($field=mysql_fetch_row($result)) {
$posted=$field[0];

$posted is a timestamp
ie: 20050422121340

$today

I need an example of the code. ie, posted 1 hour 30 min for example.

any help would be greatly appreicated.

Options: ReplyQuote


Subject
Written By
Posted
elasped time between to dates
April 28, 2005 11:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.