영카트5에서 상품 카테고리가 나오는부분이요. 채택완료

<?php

&nbsp; &nbsp; &nbsp; $ca_id_j = substr($ca_id,0,2);



&nbsp; &nbsp; &nbsp; &nbsp; // 1단계 분류 판매 가능한 것만

&nbsp; &nbsp; &nbsp; &nbsp; $hsql = " select ca_id, ca_name from {$g5['g5_shop_category_table']} where length(ca_id) = '4' and ca_use = '1' and ca_id like '$ca_id_j%' order by ca_order, ca_id ";

&nbsp; &nbsp; &nbsp; &nbsp; $hresult = sql_query($hsql);

&nbsp; &nbsp; &nbsp; &nbsp; $gnb_zindex = 999; // gnb_1dli z-index 값 설정용

&nbsp; &nbsp; &nbsp; &nbsp; for ($i=0; $row=sql_fetch_array($hresult); $i++)

&nbsp; &nbsp; &nbsp; &nbsp; {

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $gnb_zindex -= 1; // html 구조에서 앞선 gnb_1dli 에 더 높은 z-index 값 부여

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 2단계 분류 판매 가능한 것만

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql2 = " select ca_id, ca_name from {$g5['g5_shop_category_table']} where LENGTH(ca_id) = '6' and SUBSTRING(ca_id,1,4) = '{$row['ca_id']}' and ca_use = '1' order by ca_order, ca_id ";

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $result2 = sql_query($sql2);

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $count = mysql_num_rows($result2);

&nbsp; &nbsp; &nbsp; &nbsp; ?>



이렇게해보세요