habe versucht das hier zum laufen zubekommen aber leider ohne Erfolg?
(benutzer, passwort, db sind richtig eingetragen habe es nur hier mal weggelassen)
Wer kann helfen?
Code: Alles auswählen
<?php
//error_reporting(E_ALL);
$host = "localhost";
$benutzer = "00000";
$passwort = "0000";
$db = "phpbb_board";
$link = mysql_connect($host, $benutzer, $passwort);
if (!$link) {
echo "Unable to connect to DB: " . mysql_error();
exit;
}
if (!mysql_select_db($db,$link)) {
echo "Unable to select DB: " . mysql_error();
exit;
}
$res = mysql_query("SELECT topic_id, topic_title, topic_views, topic_replies FROM phpbb_topics ORDER BY topic_time DESC",$link);
if (!$res) {
echo "Could not successfully run query from DB: " . mysql_error();
exit;
}
print ("<p><table width='100%' height='2%' align='center' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#0000CC' align='center'><strong>Neue Beiträge im <a href='http://mitglied.lycos.de//forum/index.php' target='_blank'>Forum</a></strong></td>
</tr>
</table><br>");
print "<table width='100%' align='right' border='0' cellspacing='0' cellpadding='0'><tr>";
$i=0;
while ($i<4 && $row = mysql_fetch_assoc($res)) {
$as = $row['topic_title'];
$ab = $row['topic_id'];
$ge = $row['topic_views'];
$tr = $row['topic_replies'];
if ($tr == 1) {
$tr1 = "Kommentar";
} else {
$tr1 = "Kommentare";
}
print ("<td bgcolor='#000088'>Beitrag $ab</td>
</tr>
<tr>
<td bgcolor='#000050'><a href='http://localhost/forum/viewtopic.php?t=$ab' target='blank'>$as</a></td>
</tr>
<tr>
<td class ='x4' bgcolor='#000078'>$ge x gelesen | $tr $tr1</td>
</tr>
<td > </td>
</tr>");
$i++;
}
print "</table>";
mysql_close($link);
?>
"); print ""; $i=0; while ($i<4 && $row = mysql_fetch_assoc($res)) { $as = $row['topic_title']; $ab = $row['topic_id']; $ge = $row['topic_views']; $tr = $row['topic_replies']; if ($tr == 1) { $tr1 = "Kommentar"; } else { $tr1 = "Kommentare"; } print (" Beitrag $ab
$as
$ge x gelesen | $tr $tr1
