I would like to compare two timestamps that are in a MySQL db.
The reason I have 2 timestamps, is because one updates to NOW when the page is loaded.
Before the timeStamp goes threw $dateFormat, it looks like this, if that helps any. 20030731112209
The function that I used doesn't seem to work correctly.
Tables as follows:
articleDate timestamp(14) NOT NULL,
timestampNow timestamp(14) NOT NULL,
PHP Code:
//Compare Function
function thatDate($time){
$time=time()-$time;
$weeks=$time/604800;
$days=($time%604800)/86400;
$hours=(($time%604800)%86400)/3600;
$minutes=((($time%604800)%86400)%3600)/60;
$seconds=(((($time%604800)%86400)%3600)%60);
$timestring=' ';
if(round($days)) $timestring.=round($days)."d ";
if(round($hours)) $timestring.=round($hours)."h ";
if(round($minutes)) $timestring.=round($minutes)."m";
if(!round($minutes)&&!round($hours)&&!round($days)) $timestring.=" ".round($seconds)."s";
$timestring.='';
return $timestring;
}
// Query the db
$query = "SELECT
date_format(articleDate, '$dateFormat') as articleDate,
date_format(timestampNow, '$dateFormat') as timestampNow FROM $tblName WHERE id = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_object($result);
if ($row)
{
Page outputs:
Now: <? echo $row->timestampNow; ?><br>
Date Posted: <? echo $row->articleDate; ?><br>
Article is <? echo thatDate(('articleDate')); ?> old.
The results that I'm getting.
Now: Thursday July 31st, 2003 - 12:58:48 PM
Date Posted: Thursday July 31st, 2003 - 12:53:17 PM
Article is 1d 20h 59m old. <-- Wrong
Dev Articles Community Forums Sponsor:
July 31st, 2003, 12:00 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
