Tweet
Hallo Leute, wer kann mir helfen, ich habe da ein Script einer Tabelle, dessen Inhalt die letzten 5 Beiträge eines Forums beinhalten soll, so scheint alles zu passen, aber hinschreiben tut er nichts, vielleicht könnt ihr mir anhand des Quelltextes was sagen, danke.
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="810" border="0" cellpadding="0" cellspacing="0" mm:layoutgroup="true">
<tr>
<td width="11" height="116"></td>
<td width="165" valign="top" rowspan="3"><img src="../images/ausp6.jpg" width="200" height="108"></td>
<td width="73" height="116"></td>
<td width="365" rowspan="7" valign="top">&nbsp;</td>
<td width="26" height="116"></td>
<td width="170" valign="top" height="116">&nbsp;</td>
</tr>
<tr>
<td height="24"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="39"></td>
<td></td>
<td></td>
<td rowspan="3" valign="top">
<table width="75%" border="1">
<tr>
<td><tr>
<td width="100%"><?php
//Daten aus MySQL lesen:
$mydb=mysql_connect("nitweb3.nit.at", "desein", "deswed");
if (!mydb) {
die("Keine Verbindung zu MySQL");
}
$dbname="desein";
if(!mysql_select_db($dbname, $mydb)) {
die("Keine Verbindung zur Datenbank");
}
$sql = "SELECT boardparentid, posttopic FROM bb1_posts WHERE forumID = '5' order by id desc limit 0,5";
$zeilen=mysql_query($sql, $mydb);
if (!$zeilen) {
die("Die Anfrage war nicht erfolgreicht");
}
while ($zeile=mysql_fetch_array($zeilen)) {
?>
<tr>
<td><a href="text.php?id=<?=$zeile[id]?>"
target="_blank"><?=$zeile[titel]?></a></td>
</tr>
<?php
}
mysql_close($mydb);
?></td>
</tr></td>
</tr>
</table>
<p>&nbsp;</p>
</td>
</tr>
</table>
<tr>
<td height="39"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="32"></td>
<td valign="top" rowspan="3">&nbsp;</td>
<td></td>
<td></td>
</tr>
<tr>
<td height="32"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="95"></td>
<td></td>
<td></td>
<td valign="top">&nbsp;</td>
</tr>
</body>
</html>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="810" border="0" cellpadding="0" cellspacing="0" mm:layoutgroup="true">
<tr>
<td width="11" height="116"></td>
<td width="165" valign="top" rowspan="3"><img src="../images/ausp6.jpg" width="200" height="108"></td>
<td width="73" height="116"></td>
<td width="365" rowspan="7" valign="top">&nbsp;</td>
<td width="26" height="116"></td>
<td width="170" valign="top" height="116">&nbsp;</td>
</tr>
<tr>
<td height="24"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="39"></td>
<td></td>
<td></td>
<td rowspan="3" valign="top">
<table width="75%" border="1">
<tr>
<td><tr>
<td width="100%"><?php
//Daten aus MySQL lesen:
$mydb=mysql_connect("nitweb3.nit.at", "desein", "deswed");
if (!mydb) {
die("Keine Verbindung zu MySQL");
}
$dbname="desein";
if(!mysql_select_db($dbname, $mydb)) {
die("Keine Verbindung zur Datenbank");
}
$sql = "SELECT boardparentid, posttopic FROM bb1_posts WHERE forumID = '5' order by id desc limit 0,5";
$zeilen=mysql_query($sql, $mydb);
if (!$zeilen) {
die("Die Anfrage war nicht erfolgreicht");
}
while ($zeile=mysql_fetch_array($zeilen)) {
?>
<tr>
<td><a href="text.php?id=<?=$zeile[id]?>"
target="_blank"><?=$zeile[titel]?></a></td>
</tr>
<?php
}
mysql_close($mydb);
?></td>
</tr></td>
</tr>
</table>
<p>&nbsp;</p>
</td>
</tr>
</table>
<tr>
<td height="39"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="32"></td>
<td valign="top" rowspan="3">&nbsp;</td>
<td></td>
<td></td>
</tr>
<tr>
<td height="32"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="95"></td>
<td></td>
<td></td>
<td valign="top">&nbsp;</td>
</tr>
</body>
</html>
Kommentar