Nyhedsscript - 20 næste funktion

hmmm... prøv at bruge ekspertens søge funktion... den er ganske god...

prøv fx dette spm:

http://www.eksperten.dk/spm/356192

Morten

Ellers er her den grundlæggende idé (koden skal du dog selv tilpasse):

$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$num = 20; //antal nyheder pr. side

SELECT * FROM nyheder ORDER BY id DESC LIMIT ($page-1)*$num, $num

<a href="$PHP_SELF?$page=$page-1">prev</a>
<a href="$PHP_SELF?$page=$page+1">next</a>

hmm jeg kan ikke rigtig få det til og funke tipsen.. Hvis du lige ville bruge 5 minz mere på det og sætte det ind i min kode så vil jeg være rigtig glad :D


dea_pg: Det kan jeg ikke bruge til noget!

hvorfor... det er da 100% samme problem, udover det er links det handler om at begrænse, og der skal være 5 af gange... eneste du skal ændre er alle 5-taller, og så måden du udskriver data på...

kan virkeligt ikke se forskellen!

Morten

jamen dea_pg!

Hvis du vil hjælpe mig og ha de 50 pointz så indsæt det i mit script (som jeg vil ha det) :P

hehe..

jeg kan ikke lige gennemsku hvorfor din kode er som den er, men det må du selv lege med... skabelonen er:

---
$per_side = 20;

if(isset($_GET['s'])) $start = $_GET['s'];
else $start = 0;

$query = mysql_query("SELECT * FROM tabel LIMIT $start, $per_side");
while ($row = mysql_fetch_array($query)) {

  // det man nu vil gøre for hver besked!

}
<?php
}
?>
<?php
$query = mysql_query("SELECT count(*) FROM tabel")or die(mysql_error());
$data = mysql_fetch_row($query);
$num_rows = $data[0];
$page_name = basename($_SERVER['PHP_SELF']);

if(isset($_GET['s'])){
  if($_GET['s'] <= $per_side){
    echo "<a href=\"$page_name\">Previous</a>";
  }
  else{
    $prev = $start - $per_side;
    echo "<a href=\"$page_name?s=$prev\">Previous</a>";
  }
  if($num_rows - $start > $per_side){
    echo " - ";
  }
}

if($num_rows - $start > $per_side){
  $next = $start + $per_side;
  echo "<a href=\"$page_name?s=$next\">Next</a>";
}
---

Morten

kan du ikke prøve og sætte det ind i min kode plz :)

gub: Dea's udgave ser fin ud - det er bare det du skal indbygge i dit eget script.

tipsen => den er nemli' ret fræk... ;)

gub => som sagt, gidder ikke sætte mig ind i hele din kode (kan ikke lige gennemskue hvad alt er til for)... men du må også kunne selv... (det er vel dig selv der har lavet koden til det første)

Morten

hmm oki jeg prøver så..

:)

Hvis det ikke virker så skriver jeg det jeg har prøvet.. og så må i hjæpe :)

hmm det her virker ikke:

<? include("properties.php"); ?>
<?
if($news == "Submit") {
   
    $date = time();
    mysql_query("INSERT INTO ps_nyheder VALUES ('','$date','$nGroup','$psklub_userid','$pic1','$pic2','normal','$section','$headline','$content_intro','$content')");
}

if($news == "Rediger") {
    mysql_query("UPDATE ps_nyheder SET nGroup='$nGroup',pic1='$pic1',pic2='$pic2',section='$section',headline='$headline',content_intro='$content_intro',content='$content' WHERE id='$nid'"); }
   
if($delete == "Yes") {
    mysql_query("DELETE FROM ps_nyheder WHERE id='$nid'"); }

?>       

<? top("psklub.dk | eSports-community | Nyheder"); ?>
<? include("left.php"); ?>
<?
if(!$sec) { $sec = "eSport"; }
?>
<?
    $Mq = mysql_query("SELECT *,((id*0)+rand()) AS RANDOM FROM ps_nyheder  WHERE main='$sec' ORDER BY RANDOM LIMIT 0,1");
    $Mg = mysql_fetch_array($Mq);
?>
<DIV class=header>&nbsp;<a href='comments.php?type=1&nid=<?=$Mg["id"]?>'><font color="black"><u><?=$Mg["headline"]?></u></a></div>

<table width="100%" height="100%">
<tr>
<td width="250" height="150" valign="top"><a href='comments.php?type=1&nid=<?=$Mg["id"]?>'><img src="<?=$Mg[pic2];?>" border="0" width="250" height="150" style="border: 1px solid #000000"></a></td><td valign="top">
<table height="100%" height="100%">
<tr><td>
<font color="#606060" size="2"><div class=newstext><? print(date("d.m.Y", $Mg["date"])); ?> - <a href="user.php?uid=<?=$Mg["wid"]?>"><? $author = writer($Mg["wid"]); print("$author"); ?></a> - <a href="comments.php?type=1&nid=<?=$Mg["id"]?>"><? print(comments($Mg["id"],'1')); ?></font><br> </div></td></tr>
<tr><td>

<div class=newstext><? print(nl2br($Mg["content_intro"])); ?></div><br>
</td></tr><tr><td valign="bottom"><div class=newstext>
<?
if($psklub_userid == $Mg["wid"] || $psklub_user_access == "1") {
?><font color="#606060" size="2">&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$Mg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$Mg["id"]?>">Delete</a>]</font>
<? } ?></div></td></tr>
</table>
</td>
</tr>
</table>



<br><br>

<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<DIV align="right" class=subheader>[
<?
$per_side = 20;

if(isset($_GET['s'])) $start = $_GET['s'];
else $start = 0;

$query = mysql_query("SELECT * FROM tabel LIMIT $start, $per_side");
while ($row = mysql_fetch_array($query)) {
?>

}
<?php
}
?>
<?php
$query = mysql_query("SELECT count(*) FROM tabel")or die(mysql_error());
$data = mysql_fetch_row($query);
$num_rows = $data[0];
$page_name = basename($_SERVER['PHP_SELF']);

if(isset($_GET['s'])){
  if($_GET['s'] <= $per_side){
    echo "<a href=\"$page_name\">Previous</a>";
  }
  else{
    $prev = $start - $per_side;
    echo "<a href=\"$page_name?s=$prev\">Previous</a>";
  }
  if($num_rows - $start > $per_side){
    echo " - ";
  }
}

if($num_rows - $start > $per_side){
  $next = $start + $per_side;
  echo "<a href=\"$page_name?s=$next\">Next</a>";
}
?>
]</div>
<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>


<?
if($group) {

    $q = mysql_query("SELECT * FROM ps_nyheder WHERE nGroup='$group' AND section = '$sec' ORDER BY id desc LIMIT 0,20");
    while($pg = mysql_fetch_array($q)) {
    if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table><? } ?>

<? } } if(!$group) {
    $q = mysql_query("SELECT * FROM ps_nyheder WHERE section = '$sec' ORDER BY id desc LIMIT 0,20");
    while($pg = mysql_fetch_array($q)) {
        if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>

<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<?
    }
  }
}
?>   
    <DIV align="right" class=subheader>[<a href="20naeste">20 næste</a>]</div>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<!-- indhold slut-->
<? include("right.php"); ?>


Hvor er fejlen ?

hmm vist lidt for meget kode med ;(

<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<DIV align="right" class=subheader>[
<?
$per_side = 20;

if(isset($_GET['s'])) $start = $_GET['s'];
else $start = 0;

$query = mysql_query("SELECT * FROM tabel LIMIT $start, $per_side");
while ($row = mysql_fetch_array($query)) {
?>

}
<?php
}
?>
<?php
$query = mysql_query("SELECT count(*) FROM tabel")or die(mysql_error());
$data = mysql_fetch_row($query);
$num_rows = $data[0];
$page_name = basename($_SERVER['PHP_SELF']);

if(isset($_GET['s'])){
  if($_GET['s'] <= $per_side){
    echo "<a href=\"$page_name\">Previous</a>";
  }
  else{
    $prev = $start - $per_side;
    echo "<a href=\"$page_name?s=$prev\">Previous</a>";
  }
  if($num_rows - $start > $per_side){
    echo " - ";
  }
}

if($num_rows - $start > $per_side){
  $next = $start + $per_side;
  echo "<a href=\"$page_name?s=$next\">Next</a>";
}
?>
]</div>
<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>


<?
if($group) {

    $q = mysql_query("SELECT * FROM ps_nyheder WHERE nGroup='$group' AND section = '$sec' ORDER BY id desc LIMIT 0,20");
    while($pg = mysql_fetch_array($q)) {
    if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table><? } ?>

<? } } if(!$group) {
    $q = mysql_query("SELECT * FROM ps_nyheder WHERE section = '$sec' ORDER BY id desc LIMIT 0,20");
    while($pg = mysql_fetch_array($q)) {
        if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>

<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<?
    }
  }
}
?>   
    <DIV align="right" class=subheader>[<a href="20naeste">20 næste</a>]</div>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>

hvad giver den af fejl? det er lidt nemmere når man ved hvad fejlen er, og hvor...

Morten

Den siger:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/psklub.dk/httpdocs/news.php on line 60

glemte:

Table 'psklubdk.tabel' doesn't exist

hvad tror du selv at dette betyder?

"Table 'psklubdk.tabel' doesn't exist"... måske at du har glemt at ændre "tabel" til dit tabelnavn? tror jeg nok det gør...

Morten

Hmm.. det virker heller ikke vis jeg laver

$query = mysql_query("SELECT count(*) FROM tabel")or die(mysql_error());

om til

$query = mysql_query("SELECT count(*) FROM ps_nyheder")or die(mysql_error());

så burde den ikke komme med den fejl...

men det er også noget halvindviklet gode du har lavet... det ville have godt af en oprydning + opdeling i flere filer... meget svært at finde rundt!

Morten

hmm.. Jamen det virker jo.. Jeg ska bare ha fixet det der 20 næste fis :)

Du kan ikke bruge 2 minz til lige og adde det til min kode? :P

"hjælp til selvhjælp"... husk det! http://www.ebruger.dk/faq.asp#selvhjaelp

så svaret er nej... prøv at rydt op i din kode, så kan du nok godt selv se hvad din fejl er...

Morten

hmm.. nu viser den ikke nogen fejl.. Men når man trykker på "next" så bliver den bare på samme side.. der sker ik noget

<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<DIV align="right" class=subheader>[
<?
$per_side = 20;

if(isset($_GET['s'])) $start = $_GET['s'];
else $start = 0;

$query = mysql_query("SELECT * FROM ps_nyheder LIMIT $start, $per_side");
while ($row = mysql_fetch_array($query)) {
?>
<?php
}
?>
<?php
$query = mysql_query("SELECT count(*) FROM ps_nyheder")or die(mysql_error());
$data = mysql_fetch_row($query);
$num_rows = $data[0];
$page_name = basename($_SERVER['PHP_SELF']);

if(isset($_GET['s'])){
  if($_GET['s'] <= $per_side){
    echo "<a href=\"$page_name\">Previous</a>";
  }
  else{
    $prev = $start - $per_side;
    echo "<a href=\"$page_name?s=$prev\">Previous</a>";
  }
  if($num_rows - $start > $per_side){
    echo " - ";
  }
}

if($num_rows - $start > $per_side){
  $next = $start + $per_side;
  echo "<a href=\"$page_name?s=$next\">Next</a>";
}
?>
]</div>
<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>


<?
if($group) {

    $q = mysql_query("SELECT * FROM ps_nyheder WHERE nGroup='$group' AND section = '$sec' ORDER BY id desc LIMIT 0,20");
    while($pg = mysql_fetch_array($q)) {
    if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table><? } ?>

<? } } if(!$group) {
    $q = mysql_query("SELECT * FROM ps_nyheder WHERE section = '$sec' ORDER BY id desc LIMIT 0,20");
    while($pg = mysql_fetch_array($q)) {
        if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>

<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<?
    }
  }
}
?>   
    <DIV align="right" class=subheader>[<a href="20naeste">20 næste</a>]</div>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>


Den skriver ikke nogen fejl.. Men det virker ikke når man trykker next..

nej... nok fordi du ikke har gjordt som jeg har skrevet...

direkte taget fra din ovenstående kode, bare ændre 2 ting...

---
<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<DIV align="right" class=subheader>[
<?
$per_side = 20;

if(isset($_GET['s'])) $start = $_GET['s'];
else $start = 0;

$query = mysql_query("SELECT count(*) FROM ps_nyheder")or die(mysql_error());
$data = mysql_fetch_row($query);
$num_rows = $data[0];
$page_name = basename($_SERVER['PHP_SELF']);

if(isset($_GET['s'])){
  if($_GET['s'] <= $per_side){
    echo "<a href=\"$page_name\">Previous</a>";
  }
  else{
    $prev = $start - $per_side;
    echo "<a href=\"$page_name?s=$prev\">Previous</a>";
  }
  if($num_rows - $start > $per_side){
    echo " - ";
  }
}

if($num_rows - $start > $per_side){
  $next = $start + $per_side;
  echo "<a href=\"$page_name?s=$next\">Next</a>";
}
?>
]</div>
<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>


<?
if($group) {

    $q = mysql_query("SELECT * FROM ps_nyheder WHERE nGroup='$group' AND section = '$sec' ORDER BY id desc LIMIT $start, $per_side");
    while($pg = mysql_fetch_array($q)) {
    if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table><? } ?>

<? } } if(!$group) {
    $q = mysql_query("SELECT * FROM ps_nyheder WHERE section = '$sec' ORDER BY id desc LIMIT $start, $per_side");
    while($pg = mysql_fetch_array($q)) {
        if($Mg[id] == $pg[id]) { } else {
?>
    <DIV class=subheader><b><a href='comments.php?type=1&nid=<?=$pg["id"]?>'><font color="black"><u><?=$pg["headline"]?></u></font></a></b>

<?
if($psklub_userid == $pg["wid"] || $psklub_user_access == "1") {
?>&nbsp;&nbsp;&nbsp;[<a href="news.edit.php?nid=<?=$pg["id"]?>">Edit</a>] - [<a href="news.delete.php?nid=<?=$pg["id"]?>">Delete</a>]
<? } ?>
<br><font color="#606060"><? print(date("d.m.Y @ H:i", $pg["date"])); ?></font> | <a href="user.php?uid=<?=$pg["wid"]?>"><? $author = writer($pg["wid"]); print("$author"); ?></a> | <a href="comments.php?type=1&nid=<?=$pg["id"]?>"><? print(comments($pg["id"],'1')); ?></a> </div><table width="100%"><tr><td><div class=newstext><? print(nl2br($pg["content_intro"])); ?></div></td><td width='60'><a href="comments.php?type=1&nid=<?=$pg["id"]?>"><img src="<?=$pg["pic1"];?>" border="0" width="60" height="60" style="border: 1px solid #000000"></a></td></tr></table>

<table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
<?
    }
  }
}
?> 
    <DIV align="right" class=subheader>[<a href="20naeste">20 næste</a>]</div>
    <table width="100%"><tr><td background="images/indexdivider.gif" height="4"></td></tr></table>
---

de ændrede ting er:

1) ændret alle "LIMI 0,20" til: "LIMIT $start, $per_side" scriptet skal jo have af vide hvilke poster du skal have vist...

2) fjernet:
---
$query = mysql_query("SELECT * FROM ps_nyheder LIMIT $start, $per_side");
while ($row = mysql_fetch_array($query)) {
?>
<?php
}
?>
<?php
---

det var orig. her din løkke skulle have være inde i... men det synes du åben bart ike, men det andet burde også virke...

---

Morten

tusind mange tak..

Nu virker det..

Skal du ikke ha dine pointz ?

svaa'r