/** * Function returns the feature list of products * * * @return string */ function featureList() { $id = $_POST['id']; $id = 2; $sql1 = 'select distinct a.attrib_name,a.attrib_id from attribute_table a join attribute_value_table b on a.attrib_id=b.attrib_id inner join category_attrib_table c on c.attrib_id=b.attrib_id inner join category_table d on c.subcategory_id=d.category_id where d.category_id=' . $id; $obj1 = new Bin_Query(); $obj1->executeQuery($sql1); $sql = 'select a.attrib_id,a.attrib_name,b.attrib_value_id,b.attrib_value,d.category_name,d.category_id from attribute_table a inner join attribute_value_table b on a.attrib_id=b.attrib_id inner join category_attrib_table c on c.attrib_id=b.attrib_id inner join category_table d on c.subcategory_id=d.category_id where d.category_id=' . $id; $obj = new Bin_Query(); $obj->executeQuery($sql); for ($i = 0; $i < $obj->totrows; $i++) { if ($obj->records[$i]['attrib_value_id'] != 0) { $obj->records[$i]['productCnt'] = Core_CKeywordSearch::getProductCount($obj->records[$i]['attrib_value_id']); } } return Display_DKeywordSearch::featureList($obj1->records, $obj->records); }