$datestamp= mysql_result($query_result,$number_rows-$i,"timestamp");
$tzoffset = -5;
if ($datestamp == "0000-00-00") {
$datestamp = "0000-00-00 00:00:00";
}
list($date,$time) = explode(" ",$datestamp);
list($year,$month,$day) = explode("-",$date);
list($hour,$minute,$second) = explode(":",$time);
$hour = $hour + $tzoffset;
$tstamp = mktime($hour,$minute,$second,$month,$day,$year);
$sdate = date("l, m-d-y H:i",$tstamp);
echo "| ";
echo mysql_result($query_result,$number_rows-$i,"name") . " from " . mysql_result($query_result,$number_rows-$i,"location");
echo " | " . $sdate . " | ";
echo " |