add(DIAMONDS_NAVBAR_TITLE, tep_href_link(FILENAME_FINE_JEWELRY, '', 'NONSSL')); $breadcrumb->add(GIFTS_NAVBAR_TITLE, tep_href_link(FILENAME_GIFTS, '', 'NONSSL')); require(DIR_WS_INCLUDES . 'template_top.php'); $condition = ''; if($_REQUEST['range']<=500) { $condition .= " AND p.products_price <= $_REQUEST[range]"; } if($_REQUEST['range']==1000 ) { $condition .= " AND p.products_price >= 500 AND p.products_price <= $_REQUEST[range]"; } if($_REQUEST['range']==2000) { $condition .= " AND p.products_price >= 1000 AND p.products_price <= $_REQUEST[range]"; } $product_check_query = "select * from " . TABLE_PRODUCTS . " p, " .TABLE_PRODUCTS_DESCRIPTION . " pc, ".TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " pd where c.parent_id in (22,23,24,25,26,27) and c.categories_id = pd.categories_id and pd.products_id = p.products_id and pc.products_id=p.products_id ".$condition." order by p.best_sellers DESC" ; $products_new_split = new splitPageResults($product_check_query,12); ?>