답글

2025-03-21
Warning: Trying to access array offset on null in /home/eond/web/makkuk.eond.com/public_html/bbs/view.php on line 50

Warning: Trying to access array offset on null in /home/eond/web/makkuk.eond.com/public_html/bbs/view.php on line 59

if (!$board['bo_use_list_view']) {
    if ($sql_search)
        $sql_search = " and " . $sql_search;

    // 윗글을 얻음
    $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 (!$board['bo_use_list_view']) {

    if ($sql_search)

        $sql_search = " and " . $sql_search;


    // $write가 null이 아닌지 확인

    if (isset($write) && is_array($write)) {

        // 윗글을 얻음

        $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);

        }


        // 아래글을 얻음

        $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);

        }

    } else {

        // $write가 없거나 배열이 아닌 경우의 처리

        $prev = array();

        $next = array();

    }

}


내용을 입력하세요
0