/** * This function is used to show the brand narrow search * * * @return string */ function dispBrandNarrow() { $searchoption = $_SESSION['search_option']; $id = (int) $_GET['subcatid']; if (is_int($id) && $id > 0) { $sql = 'SELECT count(brand) as count,brand FROM products_table WHERE '; $sql .= ' product_id IN ('; $sql .= Core_CFeaturedItems::evaluate($id); $sql .= ')'; if ($searchoption['Price']) { $sql .= " and msrp=" . $searchoption['Price'] . ""; } $sql .= ' group by brand'; $query = new Bin_Query(); $query->executeQuery($sql); if (count($query->records) > 0) { return Display_DFeaturedItems::displayBrandNarrow($query->records); } } }