|
|
Willkommen im Gästebuch - ich freue mich sehr auf Eure netten Einträge. |
$sql2="SELECT * FROM guestbook WHERE gb_aktiv='JA' ORDER BY gb_id DESC";
$result2=mysql_query($sql2);
$anzahl=0;
while($row2=mysql_fetch_array($result2))
{
$anzahl++;
}
?>
$sql="SELECT * FROM guestbook WHERE gb_aktiv='JA' ORDER BY gb_id DESC";
$result=mysql_query($sql);
$i=1;
while($row=mysql_fetch_array($result))
{
$gb_date_j = substr($row[gb_date],0,4);
$gb_date_m = substr($row[gb_date],4,2);
$gb_date_t = substr($row[gb_date],6,2);
$gb_date_h = substr($row[gb_date],8,2);
$gb_date_min = substr($row[gb_date],10,2);
echo ("
".$anzahl.". Eintrag vom ".$gb_date_t.".".$gb_date_m.".".$gb_date_j." - ".$gb_date_h.":".$gb_date_min." Uhr
|
|
|
Name: |
".$row[gb_name]." |
");
if($row[gb_homepage] != '')
{
echo("
Homepage: |
".$row[gb_homepage]." |
|
|
");
}
echo("
Nachricht: |
".$row[gb_message]." |
|
");
$anzahl--;
}
mysql_free_result($result);
?>
|
|
|
|
|
|
|