안녕하세요 질문 드립니다 (상품 분류에서 하위 분류도 표시하는 방법에 대한 질문) 채택완료

</p>

<p><?

$ca_id_len = strlen($ca_id);

$len2 = $ca_id_len + 2;

$len4 = $ca_id_len + 4;</p>

<p>$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)) {</p>

<p>    $row2 = sql_fetch(" select count(*) as cnt from {$g5['g5_shop_item_table']} $sql_common where (ca_id like '{$row['ca_id']}%' or ca_id2 like '{$row['ca_id']}%' or ca_id3 like '{$row['ca_id']}%') and it_use = '1'  ");</p>

<p>

    $str .= '<li>';

    $str .= '   <a href="./list.php?ca_id='.$row['ca_id'].'">'.$row['ca_name'].' ('.$row2['cnt'].')</a>';</p>

<p>    $sql_sub = " select ca_id, ca_name from {$g5['g5_shop_category_table']} where ca_id like '{$row['ca_id']}%' and length(ca_id) = $len4 and ca_use = '1' order by ca_order, ca_id ";

    $result_sub = sql_query($sql_sub);</p>

<p>    // 아래 카테고리가 있을때만 Display 하도록 한다.

    if (mysql_num_rows($result_sub))

    {

        $str .= '   <div>';

        $str .= '     <ul>';</p>

<p>        while ($row_sub=sql_fetch_array($result_sub))</p>

<p>            $row2_sub = sql_fetch(" select count(*) as cnt from {$g5['g5_shop_item_table']} $sql_common where (ca_id like '{$row_sub['ca_id']}%' or ca_id2 like '{$row_sub['ca_id']}%' or ca_id3 like '{$row_sub['ca_id']}%') and it_use = '1'  ");

            $str .= '       <li>';

            $str .= '         <a href="./list.php?ca_id='.$row_sub['ca_id'].'">'.$row_sub['ca_name'].' ('.$row2_sub['cnt'].')</a>';

            $str .= '       </li>';

        }</p>

<p>        $str .= '     </ul>';

        $str .= '   </div>';

    }</p>

<p>    $str .= '</li>';

    $exists = true;</p>

<p>}

?></p>

<p>