고수님들 질문있습니다. 정보
고수님들 질문있습니다.
본문
<? if($gr_id){ ?>
<ul class="Submenu">
<!-- Nav_V -->
<?
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'news'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_news.gif border=0></li>";
while ($row=mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2=mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time()-3600*$row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=preview'><img src=$g4[path]/common/img/layout/sub_preview.gif border=0></a></li>";
echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=review'><img src=$g4[path]/common/img/layout/sub_review.gif border=0></a></li>";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'gallery'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_gallery.gif border=0></li>";
while ($row=mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2=mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time()-3600*$row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'community'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_community.gif border=0></li>";
while ($row=mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2=mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time()-3600*$row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
?>
</ul>
<? } ?>
제가 지금 이메뉴를 이용하고 있는데 아무리 봐두 너무 지저분해서..ㅡ.,ㅡ
좀 정리좀 해주심이..
댓글 전체
<ul class="Submenu">
<!-- Nav_V -->
<?
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'news'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_news.gif border=0></li>";
while ($row = mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2 = mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time() - 3600 * $row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=preview'><img src=$g4[path]/common/img/layout/sub_preview.gif border=0></a></li>";
echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=review'><img src=$g4[path]/common/img/layout/sub_review.gif border=0></a></li>";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'gallery'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_gallery.gif border=0></li>";
while ($row = mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2 = mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time() - 3600 * $row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'community'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_community.gif border=0></li>";
while ($row = mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2 = mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time() - 3600 * $row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
?>
</ul>
<? } ?>
들여쓰기 말입니까 ㅡㅡ?