상품분류 추가

// 해당 분류에 속한 상품의 수

        $sql1 = " select COUNT(*) as cnt from {$g5['g5_shop_item_table']}

                      where ca_id = '{$row['ca_id']}'

                      or ca_id2 = '{$row['ca_id']}'

                      or ca_id3 = '{$row['ca_id']}'

                      or ca_id4 = '{$row['ca_id']}'

                      or ca_id5 = '{$row['ca_id']}'

                      or ca_id6 = '{$row['ca_id']}'

                      or ca_id7 = '{$row['ca_id']}'

                      or ca_id8 = '{$row['ca_id']}' ";

        $row1 = sql_fetch($sql1);

$sql = " select ca_id, ca_name from {$g5['g5_shop_category_table']} where ca_id like '$ca_id%' and length(ca_id) = $len2 and ca_use = '1' order by ca_order, ca_id ";
$result = sql_query($sql);
while ($row=sql_fetch_array($result)) {

    $row2 = sql_fetch(" select count(*) as cnt from {$g5['g5_shop_item_table']} where (ca_id like '{$row['ca_id']}%' or ca_id2 like '{$row['ca_id']}%' or ca_id3 like '{$row['ca_id']}%' or ca_id4 like '{$row['ca_id']}%' or ca_id5 like '{$row['ca_id']}%' or ca_id6 like '{$row['ca_id']}%' or ca_id7 like '{$row['ca_id']}%' or ca_id8 like '{$row['ca_id']}%') and it_use = '1'  ");

    $str .= '<li><a href="'.shop_category_url($row['ca_id']).'">'.$row['ca_name'].' ('.$row2['cnt'].')</a></li>';
    $exists = true;
}