특정 값을 뺴고 출력하고 싶습니다. 정보
특정 값을 뺴고 출력하고 싶습니다.본문
<?if($gr_id||$bo_table){
if($config[cf_home_ex_sub_use] == 1) $home_ex_sub = $config[cf_home_ex_sub];
else $home_ex_sub = "''";
$excgr = "(".$home_ex_sub.")";
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0' and a.gr_id not in " . $excgr . " ORDER BY a.gr_1";
$result = sql_query($sql);
?>
위의 소스가 오누리빌더의 서브 상단 메뉴출력입니다.
그룹관리에서 접근사용으로 하면 나오지 않는건 알고 있습니다.
그거말고 위에 소스에서 gr_id=11 <-- 이걸 빼고 출력하고 싶습니다.
접근권한에 체크가 되어 있어도 빼고 출력하는 방법좀 알려주세요 ^^
댓글 전체
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id
FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id
WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' )
AND a.gr_use_access = '0' and a.gr_id not in " . $excgr .
" ORDER BY a.gr_1";
echo $sql=" ... 해서 나온 query 문을 한번 올려 보세요.
FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id
WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' )
AND a.gr_use_access = '0' and a.gr_id not in " . $excgr .
" ORDER BY a.gr_1";
echo $sql=" ... 해서 나온 query 문을 한번 올려 보세요.
<table width='100%'' cellpadding='0' cellspacing='0' border='0'>
<tr height='32'>
<td width='2'><img src='<?=$sub_skin_path?>/img/box_left.gif' alt=''></td>
<td background='<?=$sub_skin_path?>/img/box_bg.gif' valign="bottom">
<?if($gr_id||$bo_table){
if($config[cf_home_ex_sub_use] == 1) $home_ex_sub = $config[cf_home_ex_sub];
else $home_ex_sub = "''";
$excgr = "(".$home_ex_sub.")";
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0' and a.gr_id not in " . $excgr . " ORDER BY a.gr_1";
$result = sql_query($sql);
?>
<table height='28' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width="10"></td>
<?
for ($i=0; $row=sql_fetch_array($result); $i++){
$gLink = (!empty($row['gr_10']))?$row['gr_10']:$g4['bbs_path'].'/'.'group.php?gr_id=' .$row['gr_id'];//그룹링크
if($row['gr_id'] == $gr_id){
echo "<td width='2' background='$sub_skin_path/img/box_over_left.gif'></td><td background='$sub_skin_path/img/box_over_bg.gif' style='padding: 3 8 0 8;' style='cursor:pointer;' onclick=location.href='".$gLink."'><span class='text1'>".$row['gr_subject']."</span></td><td width='2' background='$sub_skin_path/img/box_over_right.gif'></td>";
}else{
echo "<td width='10'></td><td><a href='".$gLink."'><span class='text2'>".$row['gr_subject']."</span></a></td><td width='10'></td>";
}
if($i < count($row)+1) echo "<td style='padding: 0 3 0 3;'><img src='$sub_skin_path/img/box_bar.gif'></td>";
}?>
</tr></table>
<?}else{echo "<table height='28' cellpadding='0' cellspacing='0' border='0'><tr><td width='10'></td><td width='2' background='$sub_skin_path/img/box_over_left.gif'></td><td background='$sub_skin_path/img/box_over_bg.gif' style='padding: 3 8 0 8;'><span class='text1'>$config[cf_home_name]</span></td><td width='2' background='$sub_skin_path/img/box_over_right.gif'></td></tr></table>";}?>
</td>
<td width='2'><img src='<?=$sub_skin_path?>/img/box_right.gif' alt=''></td>
</tr>
</table>
이걸 말씀하시는건가요?
<tr height='32'>
<td width='2'><img src='<?=$sub_skin_path?>/img/box_left.gif' alt=''></td>
<td background='<?=$sub_skin_path?>/img/box_bg.gif' valign="bottom">
<?if($gr_id||$bo_table){
if($config[cf_home_ex_sub_use] == 1) $home_ex_sub = $config[cf_home_ex_sub];
else $home_ex_sub = "''";
$excgr = "(".$home_ex_sub.")";
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0' and a.gr_id not in " . $excgr . " ORDER BY a.gr_1";
$result = sql_query($sql);
?>
<table height='28' cellpadding='0' cellspacing='0' border='0'>
<tr>
<td width="10"></td>
<?
for ($i=0; $row=sql_fetch_array($result); $i++){
$gLink = (!empty($row['gr_10']))?$row['gr_10']:$g4['bbs_path'].'/'.'group.php?gr_id=' .$row['gr_id'];//그룹링크
if($row['gr_id'] == $gr_id){
echo "<td width='2' background='$sub_skin_path/img/box_over_left.gif'></td><td background='$sub_skin_path/img/box_over_bg.gif' style='padding: 3 8 0 8;' style='cursor:pointer;' onclick=location.href='".$gLink."'><span class='text1'>".$row['gr_subject']."</span></td><td width='2' background='$sub_skin_path/img/box_over_right.gif'></td>";
}else{
echo "<td width='10'></td><td><a href='".$gLink."'><span class='text2'>".$row['gr_subject']."</span></a></td><td width='10'></td>";
}
if($i < count($row)+1) echo "<td style='padding: 0 3 0 3;'><img src='$sub_skin_path/img/box_bar.gif'></td>";
}?>
</tr></table>
<?}else{echo "<table height='28' cellpadding='0' cellspacing='0' border='0'><tr><td width='10'></td><td width='2' background='$sub_skin_path/img/box_over_left.gif'></td><td background='$sub_skin_path/img/box_over_bg.gif' style='padding: 3 8 0 8;'><span class='text1'>$config[cf_home_name]</span></td><td width='2' background='$sub_skin_path/img/box_over_right.gif'></td></tr></table>";}?>
</td>
<td width='2'><img src='<?=$sub_skin_path?>/img/box_right.gif' alt=''></td>
</tr>
</table>
이걸 말씀하시는건가요?
where 절에 a.gr_id!="gr_11" 추가해주시면 될것 같은데요~
<?if($gr_id||$bo_table){
if($config[cf_home_ex_sub_use] == 1) $home_ex_sub = $config[cf_home_ex_sub];
else $home_ex_sub = "''";
$excgr = "(".$home_ex_sub.")";
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0' and a.gr_id not in " . $excgr . " and a.gr_id != 11 ORDER BY a.gr_1";
$result = sql_query($sql);
?>
아니면
<?if($gr_id||$bo_table){
if($config[cf_home_ex_sub_use] == 1) $home_ex_sub = $config[cf_home_ex_sub];
else $home_ex_sub = "''";
$excgr = "(".$home_ex_sub.")";
$excsgr = "(11)";
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0' and a.gr_id not in " . $excgr . " and a.gr_id not in " . $excsgr . " ORDER BY a.gr_1";
$result = sql_query($sql);
?>
로 해보세요.
if($config[cf_home_ex_sub_use] == 1) $home_ex_sub = $config[cf_home_ex_sub];
else $home_ex_sub = "''";
$excgr = "(".$home_ex_sub.")";
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0' and a.gr_id not in " . $excgr . " and a.gr_id != 11 ORDER BY a.gr_1";
$result = sql_query($sql);
?>
아니면
<?if($gr_id||$bo_table){
if($config[cf_home_ex_sub_use] == 1) $home_ex_sub = $config[cf_home_ex_sub];
else $home_ex_sub = "''";
$excgr = "(".$home_ex_sub.")";
$excsgr = "(11)";
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, a.gr_10, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0' and a.gr_id not in " . $excgr . " and a.gr_id not in " . $excsgr . " ORDER BY a.gr_1";
$result = sql_query($sql);
?>
로 해보세요.