new.skin.php 를 수정하고 있어요

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>

<style>
.n_title1 { font-family:돋움; font-size:9pt; color:#FFFFFF; }
.n_title2 { font-family:돋움; font-size:9pt; color:#5E5E5E; }
</style>

<!-- 분류 시작 -->
<div align="center">
<form name=fnew method=get style="margin:0px;">
<table width="907" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td height=30>
        <!--<?=$group_select?>
        <select id=view name=view onchange="select_change()">
            <option value='w'>전체게시물
            <option value='w'>원글만
            <option value='c'>코멘트만
        </select>-->
        &nbsp;<b>가맹점찾기 : </b>
        <input type=text class=ed id='bo_subject' name='bo_subject' value='<?=$bo_subject?>'>
        <input type=submit value='검색'>

        <!--&nbsp;<b>대출자찾기 : </b>
        <input type=text class=ed id='wr_subject' name='wr_subject' value='<?=$wr_subject?>'>
        <input type=submit value='검색'>-->
        <!--<script type="text/javascript">
        function select_change()
        {
            document.fnew.submit();
        }
        document.getElementById("gr_id").value = "<?=$gr_id?>";
        document.getElementById("view").value = "<?=$view?>";
        </script>-->
    </td>
</tr>
</table>
</form>
<!-- 분류 끝 -->

<!-- 제목 시작 -->
<table width="907" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td width="4" height="33" bgcolor="#7BB2D6"><img src="<?=$new_skin_path?>/img/list_top_01.gif" width="4" height="33"></td>
    <td width="100" align="center" bgcolor="#7BB2D6" height="30"><font class=n_title1><strong>그룹</strong></font></td>
    <td width="5" align="center" valign="middle" bgcolor="#7BB2D6"><img src="<?=$new_skin_path?>/img/list_top_02.gif" width="5" height="33"></td>
    <td width="5" align="center" valign="middle" bgcolor="#EEEEEE"><img src="<?=$new_skin_path?>/img/list_top_03.gif" width="5" height="33"></td>
   
   
    <td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>대출자</strong></font></td>
    <td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>대출금</strong></font></td>
    <!--<td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>임대만기일</strong></font></td>-->
    <td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>휴대폰</strong></font></td>
    <td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>금융기관</strong></font></td>   
    <td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>상품종류</strong></font></td>   
    <td width="" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>진행상태</strong></font></td>   
    <td width="120" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>가맹점</strong></font></td>
    <td width="60" align="center" bgcolor="#EEEEEE"><font class=n_title2><strong>일시</strong></font></td>
    <td width="4" bgcolor="#EEEEEE"><img src="<?=$new_skin_path?>/img/list_top_04.gif" width="4" height="33"></td>
</tr>
<?
for ($i=0; $i<count($list); $i++)
{
$tbl = "{$g4[write_prefix]}{$bo_table}";
$sql = " select wr_154 from $tbl  where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' ";
$result = sql_query($sql);

while($row = mysql_fetch_array($result)  ) {
$cmtmsg=$row[0];
}


    $gr_subject = cut_str($list[$i][gr_subject], 10);
    $bo_subject = cut_str($list[$i][bo_subject], 10);
    $wr_subject = get_text(cut_str($list[$i][wr_subject], 40));

    echo <<<HEREDOC
<tr>
    <td align="center" height="30" colspan=3><a href='./new.php?gr_id={$list[$i][gr_id]}'>{$gr_subject}</a></td>
    <td align="center" colspan="2">&nbsp;<a href='{$list[$i][href]}'><font color="blue"><b>{$list[$i][comment]}{$wr_subject}</a></font></b></td><!--대출자-->
    <td align="center">&nbsp;{$list[$i][wr_6]}</td><!--대출금-->
    <!--<td align="center">&nbsp;{$list[$i][wr_109]}-{$list[$i][wr_110]}-{$list[$i][wr_111]}</td>임대만기일-->
    <td align="center">&nbsp;{$list[$i][wr_19]}-{$list[$i][wr_20]}-{$list[$i][wr_21]}</td><!--휴대폰-->
    <td align="center">&nbsp;<font color="red">{$list[$i][wr_1]}</font></td><!--금융기관-->
    <td align="center">&nbsp;<font color="#009900">{$list[$i][wr_5]}</font></td><!--상품종류-->
    <td align="center">&nbsp;<?=$cmtmsg?></td><!--진행상태-->
    <td align="center"><a href='./board.php?bo_table={$list[$i][bo_table]}'><font color="#999999"><b>{$bo_subject}</font></b></a></td><!--가맹점이름-->
    <td align="center" colspan=2>{$list[$i][datetime2]}</td>
    <!-- <a href="javascript:;" onclick="document.getElementById('mb_id').value='{$list[$i][mb_id]}';">&middot;</a> -->
</tr>
<tr>
    <td colspan="14" height="1" background="{$new_skin_path}/img/dot_bg.gif"></td>
</tr>
HEREDOC;
}
?>

<? if ($i == 0) { ?>
<tr><td colspan="14" height=50 align=center>게시물이 없습니다.</td></tr>
<? } ?>
<tr>
    <td colspan="14" height="30" align="center"><?=$write_pages?></td>
</tr>
</table>
</div>

new.php 는 건드리지 않았습니다~

select wr_154 from g4_write_ where wr_is_comment > 0 && wr_parent = '15'
1146 : Table 'joabank.g4_write_' doesn't exist

error file : /gnuboard4/bbs/new.php


이런 에러가 납니다 ㅠㅠ

정말 감사합니다 ㅎㅎ

$bo_table = "게시판 테이블명";
$tbl = "{$g4[write_prefix]}{$bo_table}";
$sql = " select wr_154 from $tbl  where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' ";
$result = sql_query($sql);
while($row = mysql_fetch_array($result)  ) {
$cmtmsg=$row[0];
}


이렇게 하니까 되긴 하는데

제가 게시판 2개를 통합해서 보고 있거든요 그래서 new.php를 개조한거구요

테이블 한개를 써놓으면 잘되는데

추가로 밑에다가

$bo_table = "게시판 테이블명";
$bo_table = "게시판 테이블명";

이런식으로 하면 안먹히드라구요 `ㅡ`

게시판 테이블명을 통합으로 할 수 는 없는건가요?ㅠㅠ

아참

적어주신 소스 2개 모두
$bo_table = "게시판 테이블명";
을 위에 안붙히면

select wr_154 from g4_write_ where wr_is_comment > 0 && wr_parent = '15'
1146 : Table 'joabank.g4_write_' doesn't exist

error file : /gnuboard4/bbs/new.php

이런 에러가 나네요 ㅠㅠ

정말 너~~~~무 감사합니다^_^