/**
* 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);
}
}
}
