0) { $category_sqry =" and category_id='".$Category_id."'"; } if($Brand_id >0) { $brand_sqry =" and scategory_id='".$Brand_id."'"; } include "pagination/search-pagination.php"; $entries_per_page=12; $page = (isset($_GET['page'])?$_GET['page']:1); $result = mysql_query("SELECT * from common_news where status='1' and image_upath!='' $category_sqry $brand_sqry order by sorting_order 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); //fetch category name $get_category = mysql_query("select * from subcategory where id='".$Category_id."'"); $total_category = mysql_num_rows($get_category); $fetch_category = mysql_fetch_array($get_category); $pcategory_name = $fetch_category['category_name']; $meta_title = $fetch_category['meta_title']; $meta_description = $fetch_category['meta_description']; $meta_keywords = $fetch_category['meta_keywords']; $alt_tags = $fetch_category['alt_tags']; //fetch subcategory name $get_subcategory = mysql_query("select * from subcategory where id='".$Brand_id."'"); $total_subcategory = mysql_num_rows($get_subcategory); $fetch_subcategory = mysql_fetch_array($get_subcategory); $subcategory_name = $fetch_subcategory['category_name']; ?>

0) { $i=0; while($product_details = mysql_fetch_object($sel_product_rows)) { $i=$i+1; $row_id = $product_details->id; $pcategory_id = $product_details->category_id; $psubcateory_id = $product_details->scategory_id; $title=$product_details->title; $image_upath=$product_details->image_upath; $sel_product_cat_name = mysql_query("select * from subcategory where id='".$product_cat_id."' and status='1'"); $fetch_product_cat_name = mysql_fetch_object($sel_product_cat_name); if($image_upath !='') { $thumb_img_src = ''; $img_folder_path = 'uploads/common-news-images/'; $img_filename_arr = explode($img_folder_path, $image_upath); if(file_exists($img_folder_path.'300-'.$img_filename_arr['1'])) { $thumb_img_src = $img_folder_path.'300-'.$img_filename_arr['1']; } else { if(file_exists($image_upath)) { $thumb_img_src = $image_upath; } } } else { $thumb_img_src = ''; } ?>
12) { echo $pagination;} ?>