ROOT.'/live', 'Playboy Merchandise' => ROOT.'/live/cat/14_Playboy Merchandise'); /*==========================================================/ * product per page bit * ========================================================*/ if(isset($_GET['prodPerPage'])) { $prodPerPage = $_GET['prodPerPage']; $_SESSION['prodPerPage'] = $prodPerPage; } else if (isset($_SESSION['prodPerPage'])) { $prodPerPage = $_SESSION['prodPerPage']; } else { $prodPerPage = 12; } $product_list_query = "SELECT * FROM `products` WHERE `catid` = 14 and active = 1"; /*==========================================================/ * List Or grid View BIT * ========================================================*/ if(isset($_GET['viewType'])) { $viewType = $_GET['viewType']; $_SESSION['viewType'] = $viewType; } else if (isset($_SESSION['viewType'])) { $viewType = $_SESSION['viewType']; } else { $viewType = 'List'; } //die($start); $product_list_query = "SELECT * FROM `products` WHERE `catid` = 14 and active = 1"; if(isset($_GET['subcat'])) { $subcat = $_GET['subcat']; $subcatIsSet = $subcat; $get_subcat_name_query = "SELECT * FROM subcat WHERE `id` = $subcat"; $resource = new mysql($get_subcat_name_query); $name = $resource->row->name; $bread_array[stripslashes($name)] = ROOT."/cat/14_Playboy Merchandise?subcat=$id"; $product_list_query .= " AND (`subcat1` = $subcat or `subcat2` = $subcat or `subcat3` = $subcat)"; } else { $subcatIsSet = '';} $subcat = new mysql('SELECT * FROM subcat WHERE catid = 14'); $menu = subcat_menu('14'); /*if($subcat->num_row > 0){ $menu_subcat_part[0] = array(1, -1, 'Sub Catogaries', ROOT.'/live/products/14_Playboy Merchandise.php5'); $i = 1; foreach($subcat->res_array as $value) { $menu_subcat_part[$i] = array($i, 1, stripslashes($value['name']), ROOT."/live/products/14_Playboy Merchandise/14_Playboy Merchandise.php5?subcat=$value[id]"); $i++; } $menu_subcat_part[$i] = array($i, 1, stripslashes('All Playboy Merchandise'), ROOT."/live/products/14_Playboy Merchandise/14_Playboy Merchandise.php5"); $count = count($menu_subcat_part); $menu = default_menu(); for($g = 0; $g >= count($menu); $g++) { $menu[$g][0] += $count; } $menu = array_merge($menu_subcat_part, $menu); } else { $menu = default_menu(); } */ /*============================================================= * Calculate start and end limits * ============================================================*/ $get_number_of_products = new mysql($product_list_query); $number = $get_number_of_products->num_row; if($prodPerPage == 'All') {$prodPerPage = $number;} $remainder = $number % $prodPerPage; $pages = ($number - $remainder) / $prodPerPage +1; if(isset($_GET['start'])){ $start = $_GET['start']; $startLimit = $start * $prodPerPage; if($pages == $start) { $endLimit = $get_number_of_products->num_row; } //if this is the last page else { $endLimit = ($start + 1)*$prodPerPage; } //if this is any other page } else { $startLimit = 0; $endLimit = $prodPerPage; $_GET['start'] = 0; $start = 0; } $product_list_query = $product_list_query." LIMIT $startLimit, $endLimit"; $products = new mysql($product_list_query); /* echo '
| '.$value.' | ';} echo '