이게 이부분 전체 소스 입니다..........


function GetChildCategory( $d_cat_cd, $is_utf = false )
{
$child_category = array();

$sql = "
select
a.d_cat_nm, a.d_cat_cd
, (
select count(*)
from category_goods b
inner join goods c on b.goods_no = c.goods_no and b.goods_sub = c.goods_sub
where b.cat_type = '$this->cat_type' and b.d_cat_cd = a.d_cat_cd
and c.sale_stat_cl in ('30', '40')
) as goods_cnt
from category a
where a.cat_type = '$this->cat_type'
and a.p_d_cat_cd = '$d_cat_cd'
and a.use_yn = 'Y'
group by a.d_cat_cd
order by a.seq, a.d_cat_cd
";
$rs = $this->db->Execute($sql);
while ( ! $rs->EOF )
{
$d_cat_nm = htmlspecialchars($rs->fields["d_cat_nm"]);
$d_cat_cd = $rs->fields["d_cat_cd"];
$goods_cnt = $rs->fields["goods_cnt"];

    $sql_sub = "select  if(datediff(now(),reg_dm ) <= '7','Y','N') as is_new from goods WHERE left(rep_cat_cd,6) ='$d_cat_cd'  order by reg_dm desc LIMIT 0 , 1 ";
$rs_subt = $this->db->Execute($sql_sub);
$is_new = $rs_subt->fields["is_new"];



$child_category[] = array(
"d_cat_nm" => ( $is_utf ) ? iconv("EUC-KR", "UTF-8", $d_cat_nm) : $d_cat_nm
, "d_cat_cd" => $d_cat_cd
, "goods_cnt" => $goods_cnt
, "is_new" => $is_new
);
$rs->MoveNext();
}
$rs->Close();

return $child_category;
}