VIDEOS IN THE '' CATEGORY:
query($count_sql);
$CRS = $db->fetch_array($CRSQ);
$total_records = $CRS[num_records];
// we get the current page from $_GET
if (isset($_GET['pg'])){
$page = (int) $_GET['pg'];
}
$pglink=$_SESSION[baseurl]."/".$thiscat."/page";
// create the pagination class
$pagination = new Pagination();
$pagination->setLink($pglink."%s");
$pagination->setPage($page);
$pagination->setSize($size);
$pagination->setTotalRecords($total_records);
$csql = $loop_sql." ORDER BY `video_added` DESC ". $pagination->getLimitSql();
$CRSQ = $db->query($csql);
$CRS = $db->fetch_array($CRSQ);
$x=1;
while ($CRS!=0) {
$lsql = "SELECT `cat_shortcut` FROM `categories` WHERE `id` = $CRS[video_cat_id]";
$LRSQ = $db->query($lsql);
$LRS = $db->fetch_array($LRSQ);
?>
![<? echo $CRS[video_title]; ?>](http://img.youtube.com/vi/<? echo $CRS[video_id]; ?>/default.jpg)
fetch_array($CRSQ);
}
?>
create_links();
echo $navigation; // will draw our page navigation
?>
query($csql);
$CRS = $db->fetch_array($CRSQ);
if ($CRS==0) {
?>
