Code: Select all
function updateLastSeen($id)
{
global $site_db;
$time = time();
$query = sprintf("UPDATE r_users SET last_seen='%s' WHERE id='%s' LIMIT 1",
$site_db->escape($time), $site_db->escape($id));
$site_db->query($query);
return $time;
}Code: Select all
<?=date($_SESSION['site_dtformat'], $user['last_seen'])?>last_seen = 1231216344
output = Jan 5th 2009 20:01 pm