최근글 특정게시판에 예비필드 wr_1에 1값이 잇는것만 출력 정보
최근글 특정게시판에 예비필드 wr_1에 1값이 잇는것만 출력
본문
안녕하세요.........아래소스는 메인에 출력되는 최근글소스입니다.
이 소스에서 게시물에 wr_1에 1값이 잇는것만 메인에 출력이 되게 하고 싶습니다.
--------------------------------------------------------------------소스시작
<?
// 게시판
$tmp_table = "hot";
// colspan
$colspan = "3";
// 가로 이미지 수
$mod = "1";
$IMG_WIDTH = "720";
// 출력갯수
$rows = "1";
$quality = "100";
?>
<script type="text/javascript" src="<?=$g4[path]?>/tab.js"></script>
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<!-- new start //-->
<div class="new">
<div class="new_list">
<dl>
<dt><div class="tit"><span class="title"><img src="./img/bar-tp.png" border="0"></span></div><div class="btn"><a href="javascript:sidelistTab('prev', '1');" onfocus="this.blur();"><img src="./img/ss-prev.gif" border="0"></a><a href="javascript:sidelistTab('next', '1');" onfocus="this.blur();"><img src="./img/ss-next.gif" border="0"></a></div><div class="num"><span id="side_num1" class="side_num1">1</span><span class="side_num2">/</span><span class="side_num3">3</span></div></dt>
<dd>
<div id="side_list1_tab1" style="display:inline;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
// 초기화
$AddNoticeCnt = "";
$AddGalleryNotice = "";
$AddGallery = "";
$j = "0";
$sql = " select wr_id, wr_subject, wr_content, wr_link1, wr_link2 from {$g4[write_prefix]}{$tmp_table} where wr_is_comment = '0' order by wr_id desc limit 0, $rows ";
$result = sql_query($sql);
for ($i=0; $data=sql_fetch_array($result); $i++) {
// 제목
$subject = conv_subject($data['wr_subject'], $subject_len, '');
// href
$href = $g4['bbs_path']."/board.php?bo_table=".$tmp_table."&wr_id=".$data['wr_id'];
if ($data[wr_link1]) {
$hrefLink = $data[wr_link1];
} else {
if ($data[wr_link2]) {
$hrefLink = $data[wr_link2] . " target=_blank";
} else {
$hrefLink = $href;
}
}
// 이미지 체크
$sql = " select bf_file from $g4[board_file_table] where bo_table = '{$tmp_table}' and wr_id = '{$data['wr_id']}' and bf_type in (1,2,3) ";
$listFile = sql_fetch($sql);
if($listFile['bf_file']) { // 첨부파일이 있으면
$src = "{$g4[path]}/data/file/{$tmp_table}/{$listFile['bf_file']}";
$thumfile = "<a href='".$hrefLink."' onfocus='this.blur();' title='{$data['wr_subject']}'><img src='{$src}' border='0' width='720' height='130' \></a>";
}
$j++;
if ($j && $j%$mod == '1') {
$AddGallery .= "</tr>\n<tr><td colspan='".$mod."' height='1'></td></tr>\n<tr>\n";
}
$AddGallery .= "<td width='".$IMG_WIDTH."' style='padding:0 15px 0 15px;' align='center' valign='top'>";
$AddGallery .= "".$thumfile."";
$AddGallery .= "</td>\n";
}
// 나머지 셀을 채운다.
$k = $j;
$cnt = $k%$mod;
if ($cnt) {
for ($k=$cnt; $k<$mod; $k++) {
$AddGallery .= "<td width='".$IMG_WIDTH."'></td>\n";
}
}
?>
<tr><?=$AddGallery?></tr>
<? if (!$i) { echo "<tr><td colspan='".$mod."' height='100' align='center'><span class='text'>등록된 컨텐츠가 없습니다.</span></td></tr>"; } ?>
</table>
</div>
</dd>
</dl>
</div>
</div>
<!-- new end //-->
<td>
</tr>
</table>
답변 부탁드려요 ^^
이 소스에서 게시물에 wr_1에 1값이 잇는것만 메인에 출력이 되게 하고 싶습니다.
--------------------------------------------------------------------소스시작
<?
// 게시판
$tmp_table = "hot";
// colspan
$colspan = "3";
// 가로 이미지 수
$mod = "1";
$IMG_WIDTH = "720";
// 출력갯수
$rows = "1";
$quality = "100";
?>
<script type="text/javascript" src="<?=$g4[path]?>/tab.js"></script>
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<!-- new start //-->
<div class="new">
<div class="new_list">
<dl>
<dt><div class="tit"><span class="title"><img src="./img/bar-tp.png" border="0"></span></div><div class="btn"><a href="javascript:sidelistTab('prev', '1');" onfocus="this.blur();"><img src="./img/ss-prev.gif" border="0"></a><a href="javascript:sidelistTab('next', '1');" onfocus="this.blur();"><img src="./img/ss-next.gif" border="0"></a></div><div class="num"><span id="side_num1" class="side_num1">1</span><span class="side_num2">/</span><span class="side_num3">3</span></div></dt>
<dd>
<div id="side_list1_tab1" style="display:inline;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
// 초기화
$AddNoticeCnt = "";
$AddGalleryNotice = "";
$AddGallery = "";
$j = "0";
$sql = " select wr_id, wr_subject, wr_content, wr_link1, wr_link2 from {$g4[write_prefix]}{$tmp_table} where wr_is_comment = '0' order by wr_id desc limit 0, $rows ";
$result = sql_query($sql);
for ($i=0; $data=sql_fetch_array($result); $i++) {
// 제목
$subject = conv_subject($data['wr_subject'], $subject_len, '');
// href
$href = $g4['bbs_path']."/board.php?bo_table=".$tmp_table."&wr_id=".$data['wr_id'];
if ($data[wr_link1]) {
$hrefLink = $data[wr_link1];
} else {
if ($data[wr_link2]) {
$hrefLink = $data[wr_link2] . " target=_blank";
} else {
$hrefLink = $href;
}
}
// 이미지 체크
$sql = " select bf_file from $g4[board_file_table] where bo_table = '{$tmp_table}' and wr_id = '{$data['wr_id']}' and bf_type in (1,2,3) ";
$listFile = sql_fetch($sql);
if($listFile['bf_file']) { // 첨부파일이 있으면
$src = "{$g4[path]}/data/file/{$tmp_table}/{$listFile['bf_file']}";
$thumfile = "<a href='".$hrefLink."' onfocus='this.blur();' title='{$data['wr_subject']}'><img src='{$src}' border='0' width='720' height='130' \></a>";
}
$j++;
if ($j && $j%$mod == '1') {
$AddGallery .= "</tr>\n<tr><td colspan='".$mod."' height='1'></td></tr>\n<tr>\n";
}
$AddGallery .= "<td width='".$IMG_WIDTH."' style='padding:0 15px 0 15px;' align='center' valign='top'>";
$AddGallery .= "".$thumfile."";
$AddGallery .= "</td>\n";
}
// 나머지 셀을 채운다.
$k = $j;
$cnt = $k%$mod;
if ($cnt) {
for ($k=$cnt; $k<$mod; $k++) {
$AddGallery .= "<td width='".$IMG_WIDTH."'></td>\n";
}
}
?>
<tr><?=$AddGallery?></tr>
<? if (!$i) { echo "<tr><td colspan='".$mod."' height='100' align='center'><span class='text'>등록된 컨텐츠가 없습니다.</span></td></tr>"; } ?>
</table>
</div>
</dd>
</dl>
</div>
</div>
<!-- new end //-->
<td>
</tr>
</table>
답변 부탁드려요 ^^
댓글 전체
$sql = " select wr_id, wr_subject, wr_content, wr_link1, wr_link2 from {$g4[write_prefix]}{$tmp_table} where wr_is_comment = '0' order by wr_id desc limit 0, $rows ";
를 아래처럼 수정해보세요
$sql = " select wr_id, wr_subject, wr_content, wr_link1, wr_link2 from {$g4[write_prefix]}{$tmp_table} where wr_is_comment = '0' and wr_1 = '1' order by wr_id desc limit 0, $rows ";
를 아래처럼 수정해보세요
$sql = " select wr_id, wr_subject, wr_content, wr_link1, wr_link2 from {$g4[write_prefix]}{$tmp_table} where wr_is_comment = '0' and wr_1 = '1' order by wr_id desc limit 0, $rows ";

잘 됩니다 정말 감사드립니다 ^^