"; while (list($CUID, $CUsername, $Joined, $LastLogon) = mysql_fetch_row($result)) { //$Joined = Date("d/m/y - g:ia", $Joined); //$Joined = relative_date($Joined); if ($LastLogon == 0) { $LastLogon = "Never"; } else { //$LastLogon = Date("d/m/y - g:ia", $LastLogon); //$LastLogon = date('M j, Y', $LastLogon); //$LastLogon = relative_date($LastLogon); } //$LastLogon = Date("l, M jS. g:iA", $LastLogon); Echo ""; } Echo "
IDDisplay name:Joined On:Last Logon
$CUID $CUsername $Joined $LastLogon


"; //Thank you: //http://snippets.dzone.com/posts/show/196 function relative_date($time) { $today = strtotime(date('M j, Y')); $reldays = ($time - $today)/86400; if ($reldays >= 0 && $reldays < 1) { return 'Today'; } else if ($reldays >= 1 && $reldays < 2) { return 'Tomorrow'; } else if ($reldays >= -1 && $reldays < 0) { return 'Yesterday'; } if (abs($reldays) < 7) { if ($reldays > 0) { $reldays = floor($reldays); return 'in ' . $reldays . ' day' . ($reldays != 1 ? 's' : ''); } else { $reldays = abs(floor($reldays)); return $reldays . ' day' . ($reldays != 1 ? 's' : '') . ' ago'; } } if (abs($reldays) < 182) { return date('l, F j',$time ? $time : time()); } else { return date('l, F j, Y',$time ? $time : time()); } } ?>