include "/home/www/_inc/dbgo_config.inc"; ?> include "../_inc/header.inc"; ?> $MODE = $_REQUEST["MODE"]; $p = $_REQUEST["p"]; if(!$MODE){ $MODE="QnA"; } $plusQuery.=" and MODE='$MODE' and A.LEVEL in ('','".$MEMINFO["LEVEL"].",') and OPEN='Y' "; $plusQuery.=" and A.UIDX= {$memVerInfo['UIDX']} "; if($field && $key && trim($key)!=''){ $plusQuery.=" and $field like '%".trim($key)."%' "; } $query =" select count(*) as cnt from {$DBTABLE['board']} A left join {$DBTABLE['memver']} B ON A.UIDX=B.UIDX where 1 $plusQuery "; $result=mysqli_query($dbCon,$query) or die("db error"); $row_cnt = mysqli_fetch_array($result); $total = $row_cnt["cnt"]; if(!$linesu)$linesu=50; $psu=10; if(!$p) $p=1; $start=($p-1)*$linesu; $end=$start+$linesu; $totp=ceil($total/$linesu); $query ="select A.*, B.ID, B.NAME, B.LEVEL ,TIMESTAMPDIFF(DAY,A.WDATE,now()) DIFFDAY, "; $query.="(select count(*) from {$DBTABLE['board_cmt']} where BIDX = A.BIDX) RECNT "; $query.="from {$DBTABLE['board']} A left join {$DBTABLE['memver']} B ON A.UIDX=B.UIDX where 1 $plusQuery "; $query.=" order by if(A.NOTI > 0,CAST(NOTI as signed) ,999999) asc, if(A.UIDX=0, A.UIDX , 1) asc, BIDX DESC limit $start, $linesu"; //echo $query; $result=mysqli_query($dbCon,$query) or die("db error ".mysqli_error($dbCon)); $n = mysqli_num_rows($result); ?>
| No | 제목 | 등록자 | 등록일자 | 처리상태 |
|---|---|---|---|---|
| ".$j." | ".$row['TITLE']." | ".$row['ID']." | ".$row['WDATE']." | ".$recnt." |