카테고리 질문좀 드리겠습니다.

http://sir.co.kr/bbs/board.php?bo_table=yc4_qa&wr_id=29682&sca=&sfl=wr_subject%7C%7Cwr_content&stx=%EC%B9%B4%ED%85%8C%EA%B3%A0%EB%A6%AC+2%EC%B0%A8&sop=and&spt=-10361&page=1

위 링크의 코멘트를 참고하여 주십시오.



<?
include_once("./_common.php");
?>
<style type="text/css">
.ul2 {width:80%; padding:0;}
.li2 {float:left; list-style:none; width:50%; margin:0; padding:0; }
</style>
<?
// 1차 분류
$sql = " select * from $g4[yc4_category_table] where ca_use = 1 and length(ca_id) = 2 order by ca_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
if ($i==0) { echo "<ul>"; }

echo "<li>$row[ca_name]</li>";

// 2차 분류
$sql2 = " select * from $g4[yc4_category_table] where ca_use = 1 and length(ca_id) = 4 and ca_id like '$row[ca_id]%' order by ca_id ";
$result2 = sql_query($sql2);
for ($k=0; $row2=sql_fetch_array($result2); $k++) {
if ($k==0) { echo "<ul class='ul2'>"; }

echo "<li class='li2'>$row2[ca_name]</li>";
}
if ($k>0) { echo "</ul>"; }
}
if ($i>0) { echo "</ul>"; }
?>

감사합니다.^