페이지 번호를 클릭하면 게시판이 존재하지 않는다고 나옵니다.(영어로 Board is not exist)
본문
아래의 소스를 이용해서 마이페이지를 만들고 있습니다.
페이지 번호를 클릭하면 게시판이 존재하지 않는다고 나옵니다.(영어로 Board is not exist)
게시판을 My Page라고 만들어 그 곳에서 사용하고 있습니다.
감사합니다.
<!--페이징 있는 것----------------------------------------------------------------------------->
<table width="92%" cellspacing="0" cellpadding="0">
<tr>
<td width="7" height="7"><img src="<?=$g4[path]?>/img/line_mid_p1.gif"></td>
<td background="<?=$g4[path]?>/img/line_mid_p5.gif"></td>
<td width="7"><img src="<?=$g4[path]?>/img/line_mid_p2.gif"></td>
</tr>
<tr>
<td background="<?=$g4[path]?>/img/line_mid_p8.gif"></td>
<td>
<?
// 나의 최근게시물
if ($member[mb_id])
{
//환경설정하세요. by 헐랭이
$new_count = 7; //한번에 보여줄 갯수
$page_count = 5; //페이지출력수
$sql2 = " select count(*) as cnt from $g4[board_new_table]
where wr_id = wr_parent and mb_id = '$member[mb_id]' ";
$row2 = sql_fetch($sql2);
$total_count = number_format($row2[cnt]);
$rows = $page_count;
$total_page = ceil($total_count / $rows);
if (!$page) { $page = 1; }
$from_record = ($page - 1) * $rows;
$sql = " select bo_table, wr_parent from $g4[board_new_table] a
where mb_id = '$member[mb_id]'
and a.wr_id = a.wr_parent
group by bo_table, wr_parent
order by bn_id desc limit $from_record, $new_count ";
$res = sql_query($sql);
echo "<table width=95% cellpadding=0 cellspacing=0 align=center>";
echo "<tr height=25><td><img src='$g4[path]/img/list_icon.gif'> <a href='$g4[bbs_path]/new.php?view=w&mb_id=$member[mb_id]'><span style='color:#333333;'><b>My products ({$total_count}) </b></span></a></td></tr><tr><td height=1 bgcolor=#FF9900></td></tr>";
$list = array();
for ($i=0; $row=sql_fetch_array($res), $i<$new_count; $i++)
{
if (!$row[bo_table])
{
continue;
}
$tmp_table = $g4[write_prefix].$row[bo_table];
$sql2 = " select wr_subject, wr_comment from $tmp_table where wr_id = '$row[wr_parent]' ";
$row2 = sql_fetch($sql2);
$list[$i] = $row2;
$subj = get_text($list[$i][wr_subject]);
$comment = "";
if ($list[$i][wr_comment])
$comment = "<span class=small>({$list[$i][wr_comment]})</span>";
echo "<tr height=23><td class=bg_menu2 title='$subj'>";
echo "<nobr style='display:block;overflow:hidden;width:160px;'>";
echo "<img src='$g4[path]/img/list_icon2.gif'> <a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]'>";
echo "<span style='color:#666666;'>$comment $subj</span></a>";
echo "</nobr></td></tr>";
// $cnt++;
}
if (!$total_count) {
echo "<tr><td><span style='color:gray;'>게시글이 없습니다.</span></td></tr>";
}else{
echo "<tr><td><span style='color:gray;'>";
$page = get_paging($page_count, $page, $total_page, "?page=");
echo "$page";
echo "</span></td></tr>";
}
echo "</table>\n";
}
?>
</td>
<td background="<?=$g4[path]?>/img/line_mid_p6.gif"></td>
</tr>
<tr>
<td height="7"><img src="<?=$g4[path]?>/img/line_mid_p4.gif"></td>
<td background="<?=$g4[path]?>/img/line_mid_p7.gif"></td>
<td><img src="<?=$g4[path]?>/img/line_mid_p3.gif"></td>
</tr>
</table>
<!--페이징 있는 것 끝----------------------------------------------------------------------------->