fetch_assoc(); $count = mysqli_num_rows($query); if($count > 0){ $PSeqno = $rs["seqno"] ; $PTitle = $rs["title"] ; $PReadCnt = $rs["ReadCnt"] ; $Ptime = $rs["regdate"] ; }else{ $PSeqno = "" ; $PTitle = "" ; $PReadCnt = "" ; $Ptime = "" ; } $query = mysqli_query($link, "SELECT * from inquiry Where seqno > '".$seqno."' and notice = '' order by seqno asc"); $rs=$query->fetch_assoc(); $count = mysqli_num_rows($query); if($count > 0){ $NSeqno = $rs["seqno"] ; $NTitle = $rs["title"] ; $NReadCnt = $rs["ReadCnt"] ; $Ntime = $rs["regdate"] ; }else{ $NSeqno = "" ; $NTitle = "" ; $NReadCnt = "" ; $Ntime = "" ; } $ip = $_SERVER["REMOTE_ADDR"] ; $query = mysqli_query($link, "Select seqno from BoardReadCnt Where gubn = '문의' and bseqno = '".$seqno."' and ip = '".$ip."'"); $rs=$query->fetch_assoc(); $count = mysqli_num_rows($query); if($count > 0){ $ReadYN = "Y" ; } else { $ReadYN = "N" ; } if ( $ReadYN == "N" ) { $link->begin_transaction(); try { $SQL = "INSERT INTO BoardReadCnt " ; $SQL = $SQL . " (" ; $SQL = $SQL . " gubn " ; $SQL = $SQL . " , bseqno " ; $SQL = $SQL . " , ip " ; $SQL = $SQL . ") values (" ; $SQL = $SQL . " '문의' " ; $SQL = $SQL . " , '".$seqno."' " ; $SQL = $SQL . " , '".$ip."' " ; $SQL = $SQL . " )" ; mysqli_query($link,$SQL) ; $SQL = "UPDATE inquiry set " ; $SQL = $SQL . " ReadCnt = ReadCnt + 1 " ; $SQL = $SQL . " Where seqno = '".$seqno."'" ; mysqli_query($link,$SQL) ; $link->commit(); } catch (mysqli_sql_exception $exception) { $link->rollback(); } } $query = mysqli_query($link, "SELECT Count(seqno) from BoardReadCnt Where gubn = '문의' and bseqno = '".$seqno."'") ; $count = mysqli_num_rows($query); if($count > 0){ $rs=$query->fetch_assoc(); $BoardCnt = $rs["Count(seqno)"] ; } else { $BoardCnt = 0 ; } $query = mysqli_query($link, "SELECT * from inquiry Where seqno = '".$seqno."'") ; $rs=$query->fetch_assoc(); ?>

고객센터

지원받기

상담문의

공지사항

자주하는 질문

이메일 문의

상담문의

Previous/After Posts이전/이후 게시물