## get all childs & their childs under a parent category
//get all childs & their childs
public function get_child_categories( $parent_id ){
$childtree = $this->nowbuild_child_tree($parent_id);
echo "<pre>";
print_r($childtree);
echo "</pre>";
}
//now build all child tree against parent id
public function nowbuild_child_tree( $parent_id ) {
$sqlquery = " SELECT * FROM categories where parent='" .$parent_id . "' ";
$row = $this->db->query($sqlquery)->result_array();
$allCategory = array();
if(count($row)>0){
foreach ($row as $value) {
$tempCat = array();
$cat_id = $value['id']; $tempCat['categoty_details'] = $value;
//has sub category
$hasSubCat = $this->nowbuild_child_tree($cat_id);
if(count($hasSubCat) >0 ){
$tempCat['has_sub'] = 'Y'; $tempCat['sub_category'] = $this->nowbuild_child_tree($cat_id);
//unset($tempCat['sub_category']);
}else{ $tempCat['has_sub'] = 'N';
}
array_push($allCategory, $tempCat);
}
}
return $allCategory;
}