10 nyheder pr. side!

Tror det her kan bruges:

<?
include('../header.php');
include('sql.php');

$visfra = (isset($_GET["visfra"])) ? $_GET["visfra"] : 0;
$prside = 10;

echo '<p align="center">Nyheder:</p>';

$query = mysql_query("SELECT *,DATE_FORMAT(date,'%e/%c-%y %T') AS date FROM nyheder ORDER BY id DESC LIMIT ".$visfra.", ".$prside") or die(mysql_error());

while ($row = mysql_fetch_array($query)) {
$kommentare = mysql_query("select count(id) as num_kommentare from kommentare where parent = " . $row["id"]) or die(mysql_error());
$num_kommentare = mysql_fetch_assoc($kommentare);
$num_kommentare = $num_kommentare["num_kommentare"];
    if ($i++ != 0) echo '<div class="hr"></div>';
    echo '<p><a href="laes.php?id='.$row['id'].'"><b>'.$row['overskrift'].'</b></a></p>';
    echo empty($row['billede']) ? '' : '<img border="1" src="files/'.$row['billede'].'" width="150" height="100" align="left">';
$nyhed = $row['nyhed'];
$nyhed = nl2br(htmlspecialchars($nyhed));

$nyhed = ereg_replace(":1:","<img src=../community/images/1.gif>",$nyhed);
$nyhed = ereg_replace(":2:","<img src=../community/images/2.gif>",$nyhed);
$nyhed = ereg_replace(":3:","<img src=../community/images/3.gif>",$nyhed);
$nyhed = ereg_replace(":4:","<img src=../community/images/4.gif>",$nyhed);
$nyhed = ereg_replace(":5:","<img src=../community/images/5.gif>",$nyhed);
$nyhed = ereg_replace(":6:","<img src=../community/images/6.gif>",$nyhed);
$nyhed = ereg_replace(":7:","<img src=../community/images/7.gif>",$nyhed);
$nyhed = ereg_replace(":8:","<img src=../community/images/8.gif>",$nyhed);
$nyhed = ereg_replace(":9:","<img src=../community/images/9.gif>",$nyhed);
$nyhed = ereg_replace(":10:","<img src=../community/images/10.gif>",$nyhed);
$nyhed = ereg_replace("http://([a-zA-Z0-9@:%_.~#-\?&]*)", "<a target=_blank href=\"http://\\1\">http://\\1</a>", $nyhed);
$nyhed = ereg_replace("([a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+[.]{1}[a-zA-Z0-9._-]+)","<a href=\"mailto:\\1\">\\1</a>",$nyhed);

echo $nyhed;
    echo '<p> - Skrevet af: <b><a href="../community/info.php?id='.$row['nr'].'">'.$row['username'].'</a></b> - '.$row['date'].'<br> - Kilde: <b>'.$row['kilde'].'</b>';
    echo '<br> - Kommentare: <b>' . $num_kommentare;
    echo '</b></p>';
}
echo '&nbsp;';



$antal = mysql_result(mysql_query("SELECT COUNT(*) FROM nyheder"),0);
if ($visfra > 0) {
    $bagud = $visfra-$prside;
    echo "<a href=\"".$_SERVER["PHP_SELF"]."?visfra=".$bagud."\">Forrige</a> ";
}
$page = 1;
for ($start = 0; $antal > $start; $start = $start + $prside) {
    if($visfra != $page * $prside - $prside) {
        echo "<a href=\"".$_SERVER["PHP_SELF"]."?visfra=".$start."\">".$page."</a> ";
    } else {
        echo $page." ";
    }
    $page++;
}
if ($visfra < $antal - $prside) {
    $naeste = $visfra + $prside;
    echo " <a href=\"".$_SERVER["PHP_SELF"]."?visfra=".$naeste."\">Næste</a>";
}

?>

tak smid lige et svar!

Det var så lidt