Zitat:
$news_abfrage = "SELECT titel,datum,text FROM news ORDER BY datum DESC,id DESC";
$news_ergebnis = mysql_db_query($datenbankname,$news_abfrage,$verbindung);
while (list($news_titel,$news_datum_f,$news_text) = mysql_fetch_row($news_ergebnis)) {
list($news_datum_jahr, $news_datum_monat, $news_datum_tag) = explode("-", $news_datum_f);
$news_datum = $news_datum_tag . "." . $news_datum_monat . "." . $news_datum_jahr;
echo "<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>";
echo " <TBODY>";
echo " <TR>";
echo " <TD><FONT face='MS Reference Sans Serif' color=#ffffff size=2>" . $news_titel . "</FONT></TD>";
echo " <TD width=100>";
echo " <P align=right><FONT face='MS Reference Sans Serif' color=#ffffff size=2>" . $news_datum . "</FONT></P></TD></TR></TBODY></TABLE>";
echo "<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>";
echo " <TBODY>";
echo " <TR>";
echo " <TD HEIGHT='3'></TD></TR></TBODY></TABLE>";
echo "<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>";
echo " <TBODY>";
echo " <TR>";
echo " <TD HEIGHT='2' BGCOLOR=ffffff></TD></TR></TBODY></TABLE>";
echo "<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>";
echo " <TBODY>";
echo " <TR>";
echo " <TD HEIGHT='3'></TD></TR></TBODY></TABLE>";
echo "<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>";
echo " <TBODY>";
echo " <TR>";
echo " <TD>";
echo " <FONT face='MS Reference Sans Serif' color=#ffffff size=2>" . $news_text;
echo " </FONT></P></TD></TR></TBODY></TABLE><br><br>";
}
|
Hier hab ich das Problem, dass es die neuen Zeilen, die in der Datenbank gespeichert sind, nicht wiedergibt sondern einfach alles in eine Zeile schreibt.
Wie kann ich das verhindern?