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

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

$limit = 14;
$start = $p->findStart($limit);

$query = "select * from test_results order by category asc";
$db->query($query);
$count = $db->get_num_rows();

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


$query = "select * from test_results order by category asc 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]);
		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->assign('category', '');
$smarty->display('under_graduate_training_program.tpl');
?>