영카트 상품 테이블로 이용해서 3단 메뉴 만들기 #

$sql = " select ca_id, ca_name from {$g5['g5_shop_category_table']} where ca_id like '$ca_id%' and length(ca_id) = 6 and ca_use = '1' order by ca_order, ca_id ";
$result = sql_query($sql);
$i = 0;
while ($row=sql_fetch_array($result)) {
    $count_row = 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']}%') and it_use = '1'  ");
  
    $row2 = sql_fetch(" select * 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']}%') and it_use = '1'  ");
  
    if($i == 0) {
        $str .= '<li '.(strpos($row2["ca_id"], $_REQUEST['ca_id']) !== false ? "class='active'" : "").'><a href="'.G5_THEME_MSHOP_URL.'/list.php?ca_id='.$row2['ca_id'].'">전체 <span class="prd_cnt">'.$count_row['cnt'].'</span></a></li>';
    }
  
    $str .= '<li '.(strpos($row["ca_id"], $_REQUEST['ca_id']) !== false ? "class='active'" : "").'><a href="'.shop_cate_url($row['ca_id']).'">'.$row['ca_name'].' <span class="prd_cnt">'.$count_row['cnt'].'</span></a></li>';
    $i++;
}