안녕하세요 질문 있습니다. 정보
안녕하세요 질문 있습니다.
본문
<?
if($gr_id){
echo "<ul class=\"lnb\">";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = '$gr_id'";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "<li class=\"title\">$row[gr_subject]</li>";
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>";
}
}
echo "</ul>";
}
?>
지금 이소스로 메뉴를 쓰고 있는데요
이걸 그룹별이 아닌 싸이트의 모든 그룹의 메뉴가 주루룩 나오게 하려면 어케 해야 하나요?
if($gr_id){
echo "<ul class=\"lnb\">";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = '$gr_id'";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "<li class=\"title\">$row[gr_subject]</li>";
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>";
}
}
echo "</ul>";
}
?>
지금 이소스로 메뉴를 쓰고 있는데요
이걸 그룹별이 아닌 싸이트의 모든 그룹의 메뉴가 주루룩 나오게 하려면 어케 해야 하나요?
댓글 전체
<?
echo "<ul class=\"lnb\">";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id asc";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "<li class=\"title\">$row[gr_subject]</li>";
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>";
}
}
echo "</ul>";
?>
이렇게 사용해보세요
echo "<ul class=\"lnb\">";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id asc";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "<li class=\"title\">$row[gr_subject]</li>";
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>";
}
}
echo "</ul>";
?>
이렇게 사용해보세요
오옷 진정으로 감사합니다.