<?
//SQL-Einstellungen
mysql_pconnect("nbffg.db.de","www.muffy.de","145278");
mysql_select_db("DB74455852");
if (($submit) AND ($name!="") AND ($eintrag!="")) {
$date = date("d/m/y");
$result=MYSQL_QUERY("INSERT INTO gaestebuchmzeem (id,name,email,homepage,eintrag,date)".
"VALUES ('NULL', '$name', '$email', '$homepage', '$eintrag', '$date')");
};
$result = mysql_query("select * from gaestebuchmzeem order by id desc");
if(!$rowstart) $rowstart=0;
$result = mysql_query("select * from gaestebuchmzeem order by id desc limit $rowstart,100");
$result2 = mysql_query("select * from gaestebuchmzeem");
?>
<table width="435" height="10" border="0" cellspacing="0" cellpadding="0">
<!--DWLayoutTable-->
<tr>
<td width="350" valign="top" height="303">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="348" height="10" valign="top">
<table border="0" cellspacing="1" cellpadding="1" height="10" bgcolor="#000000">
<tr>
<td height="10" width="360" valign="top" bgcolor="#E7E6C7"><b><img src="gfx/pfeil2.gif" width="10" height="10">
Gaestebuch::.</b></td>
</tr>
<tr>
<form method="post" action="<? echo $php_self ?>">
<td valign="top" width="360" align="right" height="10" bgcolor="#D3D2B3">
<br> <input type="text" name="name" size="10" value="name">
<input type="text" name="email" size="10" value="email">
<input type="text" name="homepage" size="10" value="homepage">
<br>
ohne
http:// <br> <textarea name="eintrag" cols="66" rows="2"></textarea>
<br> <input type="submit" name="submit" value="sign"> <br>
<br> </td>
</form>
</tr>
</table>
</td>
</tr>
<tr>
<td height="1"></td>
</tr>
<tr>
<td height="18" valign="top" width="360">
<?
while($r=mysql_fetch_array($result))
{
$name=$r["name"];
$name=wordwrap($name, 50, "<br>", 1); // 1)
$name=strip_tags($name,"<br>");
$email=$r["email"];
$homepage=$r["homepage"];
$eintrag=$r["eintrag"];
$eintrag=wordwrap($eintrag, 50, "<br>", 1); // 1)
$eintrag=strip_tags($eintrag,"<br>");
$id=$r["id"];
?>
</td>
</tr>
<tr>
<td height="44" valign="top">
<table width="width="360" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
<tr>
<td height="10" valign="top" width="360" bgcolor="#E7E6C7"> <img src="gfx/pfeil.gif" width="10" height="10"><? echo"[$id]:[$name]"; ?>:<a href="<? echo "mailto:$email?subject=Von MzeeM.cOm´s Gästebuch aus, schreib ich dir
"; ?>">[mAil]</a>:<a href="http://<? echo"$homepage"; ?>" target="_blank">[wWw]</a>::.</td>
</tr>
<tr>
<td widht="360" height="10" valign="top" bgcolor="#D3D2B3">
<p>
<? echo " $eintrag"; ?>
</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="1" valign="top" width="360"> <br>
<? }
?>
<?
echo " $id";
if ($rowstart>$numrows)
{?>
<a href="<? $php_self ?>?rowstart=<? echo $rowstart-100;?>"><font face="verdana"><
Neue Einträge</font></a><font face="verdana">
<?}?>
<br>
</font>
<?
$numrows=mysql_num_rows($result2);
if($rowstart+100<$numrows)
{?>
<a href="<? $php_self?>?rowstart=<?echo $rowstart+100 ;?>"><font face="verdana">Ältere
Einträge></font></a>
<? } ?>
</td>
</tr>
</table>
</td>
<td width="10" valign="top"><img src="gfx/blind.gif" width="12" height="50"></td>
<td valign="top" width="75">
<?
include("box.php");
?>
</td>
</tr>
</table>
so siehts aus!!!
