그누보드 리스트 쿼리
Linux/PHP : 2007/02/21 16:49
select * from g4_write_hotphoto where wr_is_comment = 0 order by wr_num, wr_reply limit 0, 20
<?
$tbl_name = "g4_write_hotphoto";
$sql = "select * from $tbl_name where wr_is_comment = 0 Order By wr_num, wr_reply Limit 4";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$wr_id_arr[] = $row["wr_id"];
$subject_arr[] = conv_subject($row["wr_subject"], 10, "..");
$sql = "Select bf_file from g4_board_file where wr_id = ".$row["wr_id"]." and bo_table = 'hotphoto' order by bf_no Limit 1";
$data = sql_fetch($sql);
$imgSrc[] = $data["bf_file"];
}
?>
<?
$tbl_name = "g4_write_hotphoto";
$sql = "select * from $tbl_name where wr_is_comment = 0 Order By wr_num, wr_reply Limit 4";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$wr_id_arr[] = $row["wr_id"];
$subject_arr[] = conv_subject($row["wr_subject"], 10, "..");
$sql = "Select bf_file from g4_board_file where wr_id = ".$row["wr_id"]." and bo_table = 'hotphoto' order by bf_no Limit 1";
$data = sql_fetch($sql);
$imgSrc[] = $data["bf_file"];
}
?>
TAG 그누보드
Trackback Address :: http://jjangu.pe.kr/blog/trackback/358
