while ($guest = mysql_fetch_array($guests))
{
$guest_name = $guest['guest_name'];
$guest_email = $guest['guest_email'];
$guest_time = $guest['guest_time'];
$guest_message = $guest['guest_message'];
////////////////////////////////
// The database has a timestamp record type that we can use to show the
// date the guestbook was filled out.
////////////////////////////////
$datefromdb = $guest_time;
$year = substr($datefromdb,0,4);
$mon = substr($datefromdb,4,2);
$day = substr($datefromdb,6,2);
$hour = substr($datefromdb,8,2);
$min = substr($datefromdb,10,2);
$sec = substr($datefromdb,12,2);
$orgdate = date("l F dS, Y h:i A",mktime($hour,$min,$sec,$mon,$day,$year));
echo "<TABLE BORDER=\"1\" WIDTH=\"500\">
<TR><TD>
Name: $guest_name
</TD><TD>
Date: $orgdate;
</TD></TR>
<TR><TD COLSPAN=\"3\">
$guest_message
</TD></TR>
</TABLE>
<BR>";
}
?>
