= 0 ) {
// echo "
Die vorherigen $DISPLAY_NEWS News anzeigen...
";
//}
$SQL = "SELECT * FROM `News` ORDER BY 'ID' DESC LIMIT ". $_GET["news_begin"]. ",". $_GET["DISPLAY_NEWS"];
$Erg = mysql_query($SQL, $con);
// anzahl zeilen
$news_rows = mysql_num_rows($Erg);
for ($n = 0 ; $n < $news_rows ; $n++) {
if (mysql_result($Erg, $n, "Treffen") == 0) {
echo "";
} else {
echo "
";
}
echo "".mysql_result($Erg, $n, "Betreff")."
\n";
echo " ".mysql_result($Erg, $n, "Datum").", ";
echo UID2Nick(mysql_result($Erg, $n, "UID"))."";
// avatar anzeigen?
echo DisplayAvatar (mysql_result($Erg, $n, "UID"));
echo "
\n";
echo "".nl2br(mysql_result($Erg, $n, "Text"))."
\n";
$RefID=mysql_result($Erg, $n, "ID");
$countSQL="SELECT COUNT(*) from news_comments where Refid = '$RefID'";
$countErg = mysql_query($countSQL, $con);
$countcom = mysql_result($countErg, 0, "COUNT(*)");
echo "\n\n";
}
//echo "Die nächsten $DISPLAY_NEWS News anzeigen...
\n";
echo "\n\n";
$rowerg = mysql_query("select * from News", $con);
$rows = mysql_num_rows($rowerg);
$dis_rows = round (($rows / $DISPLAY_NEWS)+0.5);
Print_Text(5);
for ($i=1; $i <= $dis_rows; $i++) {
if (!((($i * $DISPLAY_NEWS) - $_GET["news_begin"]) == $DISPLAY_NEWS)) {
echo "
$i ";
} else {
echo "$i ";
}
}
echo "