이전 다음 글이 없습니다를 처음과 마지막 게시글로 링크 채택완료

</p>

<p>

if (!$board['bo_use_list_view']) {

    if ($sql_search)

        $sql_search = " and " . $sql_search;</p>

<p>    // 윗글을 얻음

    $sql = " select wr_id, wr_subject, wr_datetime 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 (! (isset($prev['wr_id']) && $prev['wr_id'])) {

        $sql = " select wr_id, wr_subject, wr_datetime 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);

    }

    // 위의 쿼리문으로 값을 얻지 못했다면 (이전글이 없는경우 마지막글)

    if (! (isset($prev['wr_id']) && $prev['wr_id'])) {

         $sql = " select wr_id, wr_subject, wr_datetime 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);

    }</p>

<p>    // 아래글을 얻음

    $sql = " select wr_id, wr_subject, wr_datetime 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 (! (isset($next['wr_id']) && $next['wr_id'])) {

        $sql = " select wr_id, wr_subject, wr_datetime 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);

    }

        // 위의 쿼리문으로 값을 얻지 못했다면 (다음글이 없는경우 처음글)

    if (! (isset($next['wr_id']) && $next['wr_id'])) {

         $sql = " select wr_id, wr_subject, wr_datetime from {$write_table} where wr_is_comment = 0 and wr_num <> '{$write['wr_num']}' {$sql_search} order by wr_num asc, wr_reply asc limit 1 ";

        $next = sql_fetch($sql);

    }</p>

<p>}</p>

<p>