Also könnte ich das ganze so benutzen:
Code: Alles auswählen
$sql = "SELECT news_id, news_title, news_time, news_text, topic_id
FROM Magazin_News_Artikel
ORDER BY news_time DESC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$news_id = $row['news_id'];
$news_title = $row['news_title'];
$news_time = $row['news_time'];
$news_text = $row['news_text'];
$topic_id = $row['news_topic_id'];
if(empty($topic_id))
{
$url = 'http://www.deineseite.de/phpBB2/posting.php?mode=newtopic&f=50&title='.$titel.'&nid='.$news_id;
}
else
{
$url = 'http://www.deineseite.de/phpBB2/viewtopic.php?t='.$topic_id;
}
}
Oder muss ich hier noch was verändern?
Code: Alles auswählen
$sql = "SELECT news_id, news_title, news_time, news_text, topic_id
FROM Magazin_News_Artikel
ORDER BY news_time DESC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
Hab das "mysql_fetch_assoc" mal in "mysql_fetch_array" geändert, hoffe das kann man so machen.