묻고답하기
게시물 추출에서
2004.03.16 07:08
<?
// select - board_admin
// => leftmenu.php
// select - board
$board_list = array();
$board = array();
for ($i=0; $i<sizeof($db_table_n); $i++)
{
$SQL = "SELECT b_bno, b_title, b_writedate FROM `" . $db_board_id_n[$i] . "` ORDER BY b_bno DESC LIMIT 1";
//echo $SQL;
$db->ParseExec($SQL);
$db->fetchInto(&$board);
$db->parseFree();
if ($board[b_bno] != NULL)
{
$board_list[table][] = $db_table_n[$i];
$board_list[title][] = $db_title_n[$i];
//$board_list[b_bno][] = $board[b_bno];
$board_list[b_title][] = $board[b_title];
$board_list[b_writedate][] = $board[b_writedate];
} // if()
} // for()
$board_cnt = is_array($board_list[table]) ? sizeof($board_list[table]) : 0;
?> <BODY leftMargin=0 topMargin=0 ><img src="<?= $CLUB_IMG_ROOT ?>/title_board.gif" border="0" alt="" width="124" height="22">
<TABLE width="100%" border="0" cellpadding="7" cellspacing="0">
<tr>
<td colspan="2" height="5"></td>
</tr>
<tr>
<td colspan="2" height="1" background="<?= $CLUB_IMG_ROOT ?>/line1.gif"></td>
</tr>
<?
for ($i=0; $i<$board_cnt; $i++)
{
?>
<TR onmouseover="this.style.background='#efefef'" onmouseout="style.background='#fafafa'" bgcolor="fafafa">
<TD width="612"> <img src="<?= $CLUB_IMG_ROOT ?>/icon_green.gif" width="11" height="9" border="0" alt=""><a href="<?= $URL_ROOT ?>/community/module/board/boardList.php?<?= $board_list[table][$i] ?>&cl_id=<?= $cl_id?>">[
<?= $board_list[title][$i] ?>
]
<?= $board_list[b_title][$i] ?>
</a></TD>
<TD width="507" align="center">
<?= substr($board_list[b_writedate][$i], 5, 10) ?>
</TD>
</TR>
<tr>
<td colspan="2" height="1" background="<?= $CLUB_IMG_ROOT ?>/line1.gif"></td>
</tr>
<?
} // for()
?>
<?
if ($board_cnt < 1)
{ ?>
<TR onmouseover="this.style.background='#efefef'" onmouseout="style.background='+ '+ '#fafafa'" bgcolor="fafafa">
<TD colspan="2" align="center"> <img src="<?= $CLUB_IMG_ROOT ?>/icon_green.gif" width="11" height="9" border="0" alt=""> 등록된 게시물이 존재하지 않습니다.</TD>
</TR>
<?
}
?>
</TABLE>
<p><br>
<br>
게시물 추출을 하고 싶은데 이건 한개밖에 안돼네요 한 5개 뽑고 싶은데 고수님들 조언좀 해주세요..
// select - board_admin
// => leftmenu.php
// select - board
$board_list = array();
$board = array();
for ($i=0; $i<sizeof($db_table_n); $i++)
{
$SQL = "SELECT b_bno, b_title, b_writedate FROM `" . $db_board_id_n[$i] . "` ORDER BY b_bno DESC LIMIT 1";
//echo $SQL;
$db->ParseExec($SQL);
$db->fetchInto(&$board);
$db->parseFree();
if ($board[b_bno] != NULL)
{
$board_list[table][] = $db_table_n[$i];
$board_list[title][] = $db_title_n[$i];
//$board_list[b_bno][] = $board[b_bno];
$board_list[b_title][] = $board[b_title];
$board_list[b_writedate][] = $board[b_writedate];
} // if()
} // for()
$board_cnt = is_array($board_list[table]) ? sizeof($board_list[table]) : 0;
?> <BODY leftMargin=0 topMargin=0 ><img src="<?= $CLUB_IMG_ROOT ?>/title_board.gif" border="0" alt="" width="124" height="22">
<TABLE width="100%" border="0" cellpadding="7" cellspacing="0">
<tr>
<td colspan="2" height="5"></td>
</tr>
<tr>
<td colspan="2" height="1" background="<?= $CLUB_IMG_ROOT ?>/line1.gif"></td>
</tr>
<?
for ($i=0; $i<$board_cnt; $i++)
{
?>
<TR onmouseover="this.style.background='#efefef'" onmouseout="style.background='#fafafa'" bgcolor="fafafa">
<TD width="612"> <img src="<?= $CLUB_IMG_ROOT ?>/icon_green.gif" width="11" height="9" border="0" alt=""><a href="<?= $URL_ROOT ?>/community/module/board/boardList.php?<?= $board_list[table][$i] ?>&cl_id=<?= $cl_id?>">[
<?= $board_list[title][$i] ?>
]
<?= $board_list[b_title][$i] ?>
</a></TD>
<TD width="507" align="center">
<?= substr($board_list[b_writedate][$i], 5, 10) ?>
</TD>
</TR>
<tr>
<td colspan="2" height="1" background="<?= $CLUB_IMG_ROOT ?>/line1.gif"></td>
</tr>
<?
} // for()
?>
<?
if ($board_cnt < 1)
{ ?>
<TR onmouseover="this.style.background='#efefef'" onmouseout="style.background='+ '+ '#fafafa'" bgcolor="fafafa">
<TD colspan="2" align="center"> <img src="<?= $CLUB_IMG_ROOT ?>/icon_green.gif" width="11" height="9" border="0" alt=""> 등록된 게시물이 존재하지 않습니다.</TD>
</TR>
<?
}
?>
</TABLE>
<p><br>
<br>
게시물 추출을 하고 싶은데 이건 한개밖에 안돼네요 한 5개 뽑고 싶은데 고수님들 조언좀 해주세요..