findStart($limit); $query = "select lecture_id,title from lectures order by lect_date desc"; $db->query($query); $count = $db->get_num_rows(); $pages = $p->findPages($count, $limit); $query = "select lecture_id,title from lectures order by lect_date 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(); array_push($lectures,$row); } } for($a=0;$aquery($query)&&$db->get_num_rows()>0) { $row = $db->fetch_all(); } $results[$a][0] = $lectures[$a][1]; $results[$a][1] = $row; } $finaldata=""; for($a=0;$a '; $temp=1; for($b=0;$bDownload File '.$temp.' '; $temp++; } $finaldata.=' '; } if($pages>1) $pagelist = $p->pageList($_GET['page'], $pages); else $pagelist = ""; require 'Smarty.class.php'; $smarty = new Smarty; $smarty->assign("pagelist",$pagelist); $smarty->assign('data',$finaldata); $smarty->display('lectures.tpl'); ?>