';
exit;
}
######### 테이블내 모든 레코드의 각 필드값을 각각의 변수에 저장하여 출력한다. ##########
$no = mysql_result($result,0,0);
$tid = mysql_result($result,0,1);
$todr = mysql_result($result,0,2);
$tdpt = mysql_result($result,0,3);
$division = mysql_result($result,0,4);
$ishtml = mysql_result($result,0,5);
$subject = mysql_result($result,0,6);
$content = mysql_result($result,0,7);
$files = mysql_result($result,0,8);
$user_id1 = mysql_result($result,0,9);
$name1 = mysql_result($result,0,10);
$read_cnt = mysql_result($result,0,11);
$regdate = substr(mysql_result($result,0,12),0,10);
##이전글
//$query1 = "SELECT no,subject FROM ysboard WHERE division=".$division." AND tid>".$tid." ORDER BY todr DESC LIMIT 1;";
$query1 = "SELECT no,subject FROM ysboard WHERE division=".$division." AND no>".$no." ORDER BY no ASC LIMIT 1;";
$result1 = mysql_query($query1);
if ($row = mysql_fetch_array($result1)) {
$prev_no = $row[no];
$prev_subject = $row[subject];
} else {
$prev_no = "";
$prev_subject = "";
}
##다음글
//$query2 = "SELECT no,subject FROM ysboard WHERE division=".$division." AND tid<".$tid." ORDER BY todr ASC LIMIT 1;";
$query2 = "SELECT no,subject FROM ysboard WHERE division=".$division." AND no<".$no." ORDER BY no DESC LIMIT 1;";
$result2 = mysql_query($query2);
if ($row = mysql_fetch_array($result2)){
$next_no = $row[no];
$next_subject = $row[subject];
} else {
$next_no = "";
$next_subject = "";
}
## 조회수 증가
$sql = "UPDATE ysboard SET read_cnt = read_cnt + 1 WHERE no = '$no'";
$result_cnt = mysql_query($sql);
if (!$result_cnt) {
echo mysql_error($db) . '
';
exit;
}
?>
