session_start();
header("Cache-control: private");
include ('include/glsettings.php');
include ('include/connect_db.php');
echo "
Gästebuch der Donautaler";
echo "
";
$rows = mysql_query("select nachname, vorname, stadt, land, heimatseite, kommentar, datum, zeitstempel, id from $gaestebuch_table order by zeitstempel desc, id desc") or DIE (mysql_error());
$num_rows = mysql_num_rows($rows);
echo "Es haben sich bereits $num_rows Musikfreunde eingetragen.";
echo "
";
echo "Eintrag ins Gästebuch schreiben";
echo "
";
setlocale ("LC_TIME", "de_DE");
while ($row = mysql_fetch_row($rows))
{
echo "";
echo "";
echo "";
echo "";
echo "$row[1] $row[0] ";
if ($row[2] != '')
{
echo "aus $row[2] ";
}
if ($row[3] != '')
{
echo "in $row[3] ";
}
echo "schrieb am ";
if ($row[7] == 0)
{
echo $row[6];
}
else
{
echo strftime("%x %R", $row[7]);
}
echo " | ";
echo "
";
echo "";
echo "";
echo nl2br($row[5]);
echo " |
";
if ($row[4] != '')
{
if (substr($row[4], 0, 7) != "http://")
{
$urlstr = "http://$row[4]";
}
else
{
$urlstr = $row[4];
}
echo "";
echo "$urlstr";
echo " |
";
}
echo "
";
echo "
";
}
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
?>