답변 3개
$write_table = $g5['write_prefix'].$bo_table;
$cate_arr = explode('|',$board['bo_category_list']);
foreach($cate_arr as $k => $v) {
$result = sql_query("select * from $write_table where ca_name='$v' order by wr_num limit 0, 2");
while($row = sql_fetch_array($result)) $list[]= $row;
}
shuffle($list);
print_r($list);
분류별로 2개씩 가져와서 보여줘야 합니다.
Copy
$cate_arr = explode('|',$board['bo_category_list']);
foreach($cate_arr as $k => $v) {
$sql = "select * from g5_write_{$bo_table} where ca_name='$v' order by rand() limit 2";
$result = sql_query($sql);
while($row = sql_fetch_array($result)) {
echo $row['bo_subject']."<br>";
}
}
답변을 작성하려면 로그인이 필요합니다.