if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가 ?>
![]() |
|
$list1 = "";
$list2 = "";
$list3 = "";
// 1단계 분류 판매가능한것만
$hsql = " select ca_id, ca_name from $g4[yc4_category_table]
where length(ca_id) = '2'
and ca_use = '1'
order by ca_id ";
$hresult = sql_query($hsql);
$hnum = @mysql_num_rows($hresult);
for ($i=0; $row=sql_fetch_array($hresult); $i++)
{
// 2단계 분류
$menubody = "";
$onmouseover = "";
$onmouseout = "";
$sql2 = " select ca_id, ca_name from $g4[yc4_category_table]
where LENGTH(ca_id) = '4'
and SUBSTRING(ca_id,1,2) = '$row[ca_id]'
and ca_use = '1'
order by ca_id ";
$result2 = sql_query($sql2);
$hnum2 = @mysql_num_rows($result2);
for ($j=0; $row2=sql_fetch_array($result2); $j++)
{
// 3단계 분류
$sql3 = " select ca_id, ca_name from $g4[yc4_category_table]
where LENGTH(ca_id) = '6'
and SUBSTRING(ca_id,1,4) = '$row2[ca_id]'
and ca_use = '1'
order by ca_id ";
$result3 = sql_query($sql3);
$hnum3 = @mysql_num_rows($result3);
for ($k=0; $row3=sql_fetch_array($result3); $k++)
{
//카테고리 3단계 리스트
if($k == 0) $list3 .="\n"; $j_plue = ",'vSubmenu".($row2[ca_id])."',WM_RIGHT"; } else $j_plue = ",null,null";
//카테고리 2단계 리스트
if($j == 0) $list2 .= "\n"; $j_top = "'vSubmenu".($row[ca_id])."',WM_RIGHT"; } else $j_top = "null,null";
//카테고리 1단계 리스트
$list1 .= " · {$row[ca_name]} \n";
}
?>=$list1?>
=$list2?>
=$list3?>![]() |