20 næste - virker ikke med "section"
Hej eksperter!Jeg har her på eksperten fået hjælp til og lave en 20 næste funktion..
Men, det er sådan at jeg fik lukket spørgsmålet for tidligt!
På min hjemme side har jeg nemlig under news flere sektioner.. WC3, CS og en SPORTS sektion!
Men hvis jeg går ind under fx min WC3 eller sports tunering og bruger "20 næste" så skifter den til de 20 næste CS nyheder.. <--> og det skal den jo ikke :P
lidt kode:
<?
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") {
?> [<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") {
?> [<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><font color="#606060" size="2">[ <?
$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>";
}
?>
<-- Min news.php
Hvis i skal bruge mere kode så skriv endelig :=)
