Hey,
Basically I set up the coding so each page is limited to display 5 news articles, anything beyond that is moved to the next page..
The 5 most recent articles show up fine on the first page but the 2 older articles dont appear on page two. Here is the code 🙂
<?php
$title = "NEWS";
require("header.php");
$page_limit=5; // set this to the number of news items per page you want shown
?>
<p align="justify" class="style4">Noticiass</p>
<?
if ($page) {
$limit_start=($page-1)*10;
$limit="LIMIT $limit_start, $page_limit";
} else $limit="LIMIT $page_limit";
$sql = "SELECT DATE_FORMAT(date,'%m.%e.%Y'), title, content FROM site_news ORDER BY date DESC $limit";
$result = mysql_query($sql,$dbh);
$err = mysql_error();
if ($err) { echo "$err"; die; }
while(list($date, $title, $content) = mysql_fetch_array($result)) {
?>
<div align="left"><span class="style5">
<?=$title?>
<br />
</span> <span class="style3">
<?=$date?>
<br />
<br />
</span><span class="style6"><? echo stripslashes($content); ?></p><br />
</div>
<?
}
// GOTO PAGE...
$sql = "SELECT COUNT(id) FROM site_news";
$result = mysql_query($sql,$dbh);
$err = mysql_error();
if ($err) { echo "$err"; die; }
list($news_count) = mysql_fetch_array($result);
if (!$page) $page=1;
$pages_total=ceil($news_count/$page_limit);
if ($pages_total > 1) {
echo "JUMP TO NEWS PAGE:<br>";
if ($page!=1) echo "<a href=\"news.php?page=1\"><<</a> ";
else echo "<< ";
$page_last=$page-1;
if ($page_last!=0) echo "<a href=\"news.php?page=$page_last\"><</a> ";
else echo "< ";
for ($i=1; $i<=$pages_total; $i++) {
if ($i != $page) echo "<a href=\"news.php?page=$i\">$i</a> ";
else echo "$i ";
}
$page_next=$page+1;
if ($page_next<=$pages_total) echo "<a href=\"news.php?page=$page_next\">></a> ";
else echo "> ";
if ($page!=$pages_total) echo "<a href=\"news.php?page=$pages_total\">>></a> ";
else echo ">> ";
}
?>
