Rifenburg678z
New Member
I want to log the time that a user posted a message and display it in a Twitter like fashion.I found a function that does this but it does not work with mysqls Timestamp type.In the instructions it says that it uses the time()format to calculate it. How should I be writing the times to my Database in order for it to work??? This is the code:\[code\]function newTime($tm,$rcs = 0) { // http://snipplr.com/view/17338/ $cur_tm = time(); $dif = $cur_tm-$tm; $pds = array('second','minute','hour','day','week','month','year','decade'); $lngh = array(1,60,3600,86400,604800,2630880,31570560,315705600); for($v = sizeof($lngh)-1; ($v >= 0)&&(($no = $dif/$lngh[$v])<=1); $v--); if($v < 0) $v = 0; $_tm = $cur_tm-($dif%$lngh[$v]); $no = floor($no); if($no <> 1) $pds[$v] .='s'; $x=sprintf("%d %s ",$no,$pds[$v]); if(($rcs == 1)&&($v >= 1)&&(($cur_tm-$_tm) > 0)) $x .= time_ago($_tm); return $x."ago";}\[/code\]