include "../include/_prepend.php";
if(!$division) { $division = 0; }
$db = getConnection();
$query = "SELECT * FROM ysboard where no=".$no;
$result = mysql_query($query);
if (!$result) {
echo mysql_error($db) . '
';
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;
}
?>
include "noticeleft.php"; ?>
|
|
|
|
|
|
|
|
|
if ($files<>"") { ?>
|
|
} ?>
|
|
if ($user_id==$user_id1 && $user_id<>"") { ?> } ?> |
|
|
|
|
if ($prev_no!="") { ?> } ?> |
|
|
|
|
|
|
|
if ($next_no!="") { ?> } ?> |
|
|
|
|
|
include "noticeright.php"; ?>