include_once"_common.php";
# 인기글
function izen_usort1($a, $b)
{
return $b['wr_hit'] - $a['wr_hit'];
}

# 헤드라인
function izen_usort2($a, $b)
{
return $b['wr_good'] - $a['wr_good'];
}

# 헤드라인
function izen_usort3($a, $b)
{
return $b['wr_comment'] - $a['wr_comment'];
}

//sort 가 넘어옴

$limit="100"; //100개뽑음
if($sort == "wr_hit")$limit=20;

$board[bo_table]="1";
$tmp_write_table = $g4['write_prefix'] . $board[bo_table]; // 게시판 테이블 전체이름
$result = sql_query("select * from $tmp_write_table where wr_is_comment = '0' order by wr_num asc limit 0, $limit");
$list = array();

for($i=0;$row = sql_fetch_array($result);$i++){
    $list[$i] = $row;
}

if($sort == "wr_comment" || !$sort)usort($list, 'izen_usort3');
if($sort == "wr_good")usort($list, 'izen_usort2');
if($sort == "wr_hit")usort($list, 'izen_usort1');



$list= array_slice($list, 0, 14);
?>

요새 추천을 많이 받은글 뽑을라하는데 order by wr_good 10개 하면 0.08초
wr_num으로 100개를 뽑아서 그중에 wr_good순으로 재정렬해서 10개 만 쓰고 버리면  0.01초