// 윗글을 얻음
$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 (!$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);
}
// 아래글을 얻음
$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 (!$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 ($prev_href) {
$prev_wr_subject = get_text(cut_str($prev['wr_subject'], 100));
$prev_wr_datetime = substr($prev['wr_datetime'],0,10);
echo "$prev_wr_subject $prev_wr_datetime";
}else{
echo"이전글이 없습니다.";
}?> |
다음글 |
if ($next_href) {
$next_wr_subject = get_text(cut_str($next['wr_subject'], 100));
$next_wr_datetime = substr($next['wr_datetime'],0,10);
echo "$next_wr_subject $next_wr_datetime";
}else{
echo"다음글이 없습니다.";
}?> |