0 "; if (isset($keyword)) { if ($keyselect=="subject") { $querytemp = $querytemp." and subject like '%$keyword%' "; } else if ($keyselect=="comment") { $querytemp = $querytemp." and comment like '%$keyword%' "; } else if ($keyselect=="username") { $querytemp = $querytemp." and username like '%$keyword%' "; } } $query = "select pid, subject, regdate from noticeboard ".$querytemp." and kinds='$kinds' and pid<$pid order by pid desc limit 1"; $result = mysqli_query($GLOBALS['dbh'],$query); $rows = mysql_fetch_row($result); $prevpid = $rows[0]; $prevsubject = $rows[1]; $prevsubject = htmlspecialchars(stripslashes($prevsubject)); $prevregdate = $rows[2]; $query = "select pid, subject, regdate from noticeboard ".$querytemp." and kinds='$kinds' and pid>$pid order by pid asc limit 1"; $result = mysqli_query($GLOBALS['dbh'],$query); $rows = mysql_fetch_row($result); $nextpid = $rows[0]; $nextsubject = $rows[1]; $nextsubject = htmlspecialchars(stripslashes($nextsubject)); $nextregdate = $rows[2]; $query = "Select pid,userid,username,email,subject,comment,userfile, "; $query = $query." regdate,readnum, "; $query = $query." ref,step,re_level,kinds,password "; $query = $query." From noticeboard "; $query = $query.$querytemp." and kinds='$kinds' and pid='$pid' "; $result = mysqli_query($GLOBALS['dbh'],$query); $rows = mysql_fetch_row($result); $pid=$rows[0]; $userid=$rows[1]; $username=$rows[2]; $email=$rows[3]; $subject=$rows[4]; $subject=htmlspecialchars(stripslashes($subject)); $comment=$rows[5]; $comment=stripslashes($comment); $comment=nl2br($comment); $userfile=$rows[6]; $regdate=$rows[7]; $readnum=$rows[8]; $ref=$rows[9]; $step=$rows[10]; $re_level=$rows[11]; $kinds=$rows[12]; ?> ::SEOUL METAL::
 
 
     
Home > 커뮤니티 > 공지사항
 
작성자 :
작성일 :
 
윗글
아랫글