if ($privileges != 1) { //lempar ke index
?>
} ?>
$rowsPerPage = 5;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$sqlx=mysql_query("SELECT * FROM table_news order by creation_date desc LIMIT $offset, $rowsPerPage");
$row=mysql_num_rows($sqlx);
$b=0;
while($row=mysql_fetch_array($sqlx))
{
$id_news = $row[id_news];
$title = $row[title];
$description = $row[description];
$content = $row[content];
$creation_date = $row[creation_date];
$created_by = $row[created_by];
?>
echo "
".$title." (".$creation_date.") ";
echo substr($content, 0, 200)." [...] ";
?>
} ?>
$query = "SELECT COUNT(*) AS numrows FROM table_news";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
$self = "index2.php";
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = "
";
$first = " [First Page] ";
}
else
{
$prev = " "; // we're on page one, don't enable 'previous' link
$first = ' [First Page] '; // nor 'first page' link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = "
";
$last = " [Last Page] ";
}
else
{
$next = " "; // we're on the last page, don't enable 'next' link
$last = ' [Last Page] '; // nor 'last page' link
}
echo $first . $prev . " pages $pageNum of $maxPage " . $next . $last;
?>