이전작성자 변수.

// 윗글을 얻음    $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);    }

// 윗글을 얻음    $sql = " select wr_id, wr_subject, wr_name, 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_name, 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_name, 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_name, 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);    }

echo $prev['wr_name']; echo $prev['wr_datetime']; echo $next['wr_name'];echo $next ['wr_datetime'];