Código PHP:
<?
include("includes/connect.inc.php");
$query = "SELECT COUNT(*) FROM guests";
$numguests = mysql_query($query) or die("Select Failed!");
$numguest = mysql_fetch_array($numguests);
?>
<!-- This is where we report the total messages. -->
<P align="center"><font class="f1">
<? echo $numguest[0]; ?> personas han dejado un comentario.</font>
</P>
<hr>
<?
$query = "SELECT * FROM guests ORDER BY guest_time DESC LIMIT
}
$guests = mysql_query($query) or die("Select Failed!");
while ($guest = mysql_fetch_array($guests)) {
?>
<font class="f4">Nombre:</font>
<? echo $guest['guest_name']; ?></font><br>
<font class="f4">Ubicación:</font>
<? echo $guest['guest_email']; ?></font><br>
<font class="f4">
<?
$datefromdb = $guest['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));
?>
Fecha:</font>
<? echo $orgdate; ?><br>
<font class="f4">Comentario:</font><br>
<? echo $guest['guest_message']; ?>
<HR>
<BR>
<? } ?>
![Adios](http://static.forosdelweb.com/fdwtheme/images/smilies/adios.gif)