<?php
// Database Forbindelse
include 'admin_inc/db.php';

if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

// Definer max nyheter per side
$max_results = 5;

//Regn ut limit til SQL query
$from = (($page * $max_results) - $max_results);

$sql = mysql_query("SELECT news.author, news.date, news.content, news.title, users.UserID, userdata.UserType FROM news, users, userdata WHERE ((news.author = users.username) AND (users.UserID = userdata.UserID)) ORDER BY news.date DESC LIMIT $from, $max_results");
	while($rows = mysql_fetch_array($sql)){
			// Print ut artklene her
//Bare illustrerer :
			echo $rows['content']
	} 
// Regn ut totalt antall nyheter
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM news"),0);

// Regn ut antall sider, rund opp
$total_pages = ceil($total_results / $max_results);

echo "<div align=\"center\">Choose page:<br />";

// Forrige link
if($page > 1){
	$prev = ($page - 1);
	echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\">&lt;&lt;Previous</a>&nbsp;";
	} else {
		echo "&lt;&lt;Previous&nbsp;";
}	

// Tall link
for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "<strong>$i</strong>&nbsp;";
        } else {
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a>&nbsp;";
    }
}

// Neste link
if($page < $total_pages){
	$next = ($page + 1);
	echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next&gt;&gt;</a>";
	} else {
		echo "Next&gt;&gt;";
}
echo "</div>";
mysql_close($linkID);
?>