게시판 정렬에서 추천10이상인 게시물을 불러올수 있나요?
본문
<?php echo subject_sort_link('wr_good', $qstr2, 1) ?>추천순</a>
게시판 정렬에서 추천순 하면 추천수가 많은거 부터 정렬이 되는데
추천수 10이상인 게시물을 전부 불러올려면 어떻게 해야하나요?
!-->
답변 1
/bbs/list.php
if ($sca || $stx) {
$sql = " select distinct wr_parent from {$write_table} where {$sql_search} {$sql_order} limit {$from_record}, $page_rows ";
} else {
$sql = " select * from {$write_table} where wr_is_comment = 0 ";
if(!empty($notice_array))
$sql .= " and wr_id not in (".implode(', ', $notice_array).") ";
$sql .= " {$sql_order} limit {$from_record}, $page_rows ";
}
if ($sca || $stx) {
$sql = " select distinct wr_parent from {$write_table} where {$sql_search} {$sql_order} limit {$from_record}, $page_rows ";
} else {
if($sst=='wr_good'){
$sql = " select * from {$write_table} where wr_is_comment = 0 and wr_good>9";
}else{
$sql = " select * from {$write_table} where wr_is_comment = 0 ";
}
if(!empty($notice_array))
$sql .= " and wr_id not in (".implode(', ', $notice_array).") ";
$sql .= " {$sql_order} limit {$from_record}, $page_rows ";
}