// 윗글을 얻음
    $sql = " select wr_id, wr_subject from $write_table where wr_is_comment = 0 and wr_num = '$write[wr_num]' and wr_reply < '$write[wr_reply]' $sql_search order by wr_num desc, wr_reply desc limit 1 ";
    $prev = sql_fetch($sql);
    // 위의 쿼리문으로 값을 얻지 못했다면
    if (!$prev[wr_id])    {
        $sql = " select wr_id, wr_subject from $write_table where wr_is_comment = 0 and wr_num < '$write[wr_num]' $sql_search order by wr_num desc, wr_reply desc limit 1 ";
        $prev = sql_fetch($sql);
    }

    // 아래글을 얻음
    $sql = " select wr_id, wr_subject from $write_table where wr_is_comment = 0 and wr_num = '$write[wr_num]' and wr_reply > '$write[wr_reply]' $sql_search order by wr_num, wr_reply limit 1 ";
    $next = sql_fetch($sql);
    // 위의 쿼리문으로 값을 얻지 못했다면
    if (!$next[wr_id]) {
        $sql = " select wr_id, wr_subject from $write_table where wr_is_comment = 0 and wr_num > '$write[wr_num]' $sql_search order by wr_num, wr_reply limit 1 ";
        $next = sql_fetch($sql);
    }
}

// 이전글 링크
$prev_href = "";
if ($prev[wr_id]) {
    $prev_wr_subject = get_text(cut_str($prev[wr_subject], 255));
    $prev_href = "./board.php?bo_table=$bo_table&wr_id=$prev[wr_id]&page=$page" . $qstr;
}

// 다음글 링크
$next_href = "";
if ($next[wr_id]) {
    $next_wr_subject = get_text(cut_str($next[wr_subject], 255));
    $next_href = "./board.php?bo_table=$bo_table&wr_id=$next[wr_id]&page=$page" . $qstr;
}

view.php 에서 이전글 다음글 얻는 내용입니다.


function goto_img($str){
global $g4, $bo_table;
$str = explode("wr_id=", $str);
$str = explode("&", $str[1]);
$wr_id_in = $str[0];

$sql = " select bf_file from $g4[board_file_table] where wr_id = $wr_id_in and bo_table = '$bo_table' order by bf_no limit 1";
$row = sql_fetch($sql);

return $row[bf_file];
}


$next_img = goto_img($next_href);
            $next_img_thumb = thumbnail("$g4[path]/data/file/$bo_table/$next_img",160, 240, 0, 1, 70,0);
            echo "<a href=\"$next_href\" title=\"$next_wr_subject\"><img onmouseover=\"this.style. filter=''\" style=\"FILTER: gray; border-color:#cccccc;\" onmouseout=\"this.style.filter='gray'\"  src='$next_img_thumb'  border='0' align='absmiddle' style='border:#CCCCCC 5px solid;'></a>";


이것은 RINIX_3 스킨 중 불당썸 과 연계된 소스입니다.

이전과 다음은 이것으로 해결 될 겁니다.

이전이전과 다음다음은 한번 더 돌리던가
쿼리의 부담이 걱정된다면 limit 2 로 두개를 뽑아 for문으로 돌려 net1, next2 를 뽑아오십시요