include "dilg/cnt/join.php"; extract($_REQUEST); $ID=$_GET['id']; $TYPE="Videos"; $SUBTYPE=$_GET['subtype']; include "pagination/id-pagination.php"; if($TYPE =='Children_videos') { $query = mysql_query("SELECT * FROM category where status='1' and category_name='Children Menu' order by id desc"); $fetch_cate=mysql_fetch_object($query); $cat_id=$fetch_cate->id; $SubQry .= " and is_featured_product = '1' and category_name = '$cat_id'"; } else { $SubQry .= "and category_name='$ID' and type='$TYPE'"; } $entries_per_page=12; $page = (isset($_GET['page'])?$_GET['page']:1); $result = mysql_query("SELECT * FROM gallery_images where url!='' and status='1' $SubQry order by id desc"); $num_rows = mysql_num_rows($result); $total_pages = ceil($num_rows/$entries_per_page); $pagination = pagination_six($total_pages,$page); $offset = (($page * $entries_per_page) - $entries_per_page); if($TYPE =='Children_videos') { $Cate_Name="Children's Ministry"; } else { $fet_cate_name=mysql_query("SELECT * from category where status='1' and id='$ID'"); $cate_name_res=mysql_fetch_object($fet_cate_name); $Cate_Name=$cate_name_res->category_name; } ?>