<?php
require_once("admin/Database.php");
require_once("admin/class.pager.php");
$db = new Database();

$p = new Pager;
$results = array();

$limit = 10;
$start = $p->findStart($limit);
$query = "select * from news";
$db->query($query);
$count = $db->get_num_rows();

$pages = $p->findPages($count, $limit);

$query = "select * from news order by newsdate desc LIMIT ".$start.", ".$limit;

if($db->query($query)&&$db->get_num_rows()>0)
{
	for($a=0;$a<$db->get_num_rows();$a++)
	{
		$row = $db->fetch_row();
		$row[1] = stripslashes($row[1]);
		$row[2] = stripslashes($row[2]);
		array_push($results,$row);
		
	}
}

if($pages>1)
$pagelist = $p->pageList($_GET['page'], $pages);
else 
{
	$pagelist="";
}

require 'Smarty.class.php';
$smarty = new Smarty;
$smarty->assign("results",$results);
$smarty->assign("pagelist",$pagelist);
$smarty->display('rrf_news.tpl');
?>