그누보드 게시판 채택완료

상세보기 페이지에서 이전글 옆에 이전글 제목과

다음글 옆에 다음글 제목을 출력하고 싶습니다. 어떻게 해야 하는지 궁금합니다.

  // 윗글을 얻음

&nbsp; &nbsp; $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 ";

&nbsp; &nbsp; $prev = sql_fetch($sql);

&nbsp; &nbsp; // 위의 쿼리문으로 값을 얻지 못했다면

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

&nbsp; &nbsp; &nbsp; &nbsp; $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 ";

&nbsp; &nbsp; &nbsp; &nbsp; $prev = sql_fetch($sql);

&nbsp; &nbsp; }



&nbsp; &nbsp; // 아래글을 얻음

&nbsp; &nbsp; $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 ";

&nbsp; &nbsp; $next = sql_fetch($sql);

&nbsp; &nbsp; // 위의 쿼리문으로 값을 얻지 못했다면

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

&nbsp; &nbsp; &nbsp; &nbsp; $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 ";

&nbsp; &nbsp; &nbsp; &nbsp; $next = sql_fetch($sql);

&nbsp; &nbsp; }

}