add(DIAMONDS_NAVBAR_TITLE, tep_href_link(FILENAME_FINE_JEWELRY, '', 'NONSSL')); require(DIR_WS_INCLUDES . 'template_top.php'); $attrArr = simpleAttributes(); $cat=$_REQUEST['cat']; $cat_num=$_REQUEST['subcat']; $sort_sql = " ORDER BY p.best_sellers DESC"; if($cat>0 && $cat_num==0) { $product_categories_query = tep_db_query("select cd.categories_name,cd.categories_id from " .TABLE_CATEGORIES_DESCRIPTION. " cd where cd.categories_id ='".$cat."'"); $row=tep_db_fetch_array($product_categories_query); $cat= $row['categories_name']; } if($cat_num > 0){ $product_categories_query = "select cd.categories_name,cd.categories_id from " .TABLE_CATEGORIES_DESCRIPTION. " cd where cd.categories_id in ('".$cat_num."','".$cat."')"; //$row=tep_db_fetch_array($product_categories_query); $r=mysql_query($product_categories_query); $cat_name=array(); $cat_id = array(); while($row=mysql_fetch_array($r)) { $cat_name[] = $row['categories_name']; $cat_id[] = $row['categories_id']; } $product_check_query = "select * from " . TABLE_PRODUCTS . " p, " .TABLE_PRODUCTS_DESCRIPTION . " pc, ". TABLE_PRODUCTS_TO_CATEGORIES . " pd where pd.categories_id= ".$cat_num. " and pd.products_id = p.products_id and pc.products_id=p.products_id $sort_sql"; } elseif($_REQUEST['cat'] == 60){ $product_check_query = "select * from " . TABLE_PRODUCTS . " p, " .TABLE_PRODUCTS_DESCRIPTION . " pc, ".TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " pd where c.parent_id=0 and pd.categories_id = ".$_REQUEST['cat']." and c.categories_id = pd.categories_id and pd.products_id = p.products_id and pc.products_id=p.products_id $sort_sql"; } else{ $product_check_query = "select * from " . TABLE_PRODUCTS . " p, " .TABLE_PRODUCTS_DESCRIPTION . " pc, ".TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " pd where c.parent_id='".$_REQUEST['cat']."' and c.categories_id = pd.categories_id and pd.products_id = p.products_id and pc.products_id=p.products_id $sort_sql"; } $products_new_split = new splitPageResults($product_check_query,12); //echo $product_check_query; //die; ?>