query("select * from event where c_title like '%$search%' order by ref DESC,re_step asc,c_date desc"); } } else $db->query("select * from event order by ref DESC,re_step asc,c_date desc "); $totalCount = $db->row_count(); $total = $db->row_count(); $recPg = 10; $totalPg = ceil($totalCount/$recPg); if(!$nPage) $nPage=1; $startP = ($nPage-1)*$recPg; $endP = $recPg; $total = $total-(($nPage*$recPg)-$recPg); $a=$total; // page include "../lib/pageskin.php"; //생성자 (URL, 데이터전체갯수, 라인줄수, 하단페이지이동갯수) $pageSkip = new pageSkip($_SERVER['PHP_SELF']."?search=$search&period=$period&nPage=", $totalCount, $recPg, 10); //////////////// if($search) { if($select == "제목"){ $db->query("select * from event where c_title like '%$search%' order by ref DESC,re_step asc,c_date desc limit $startP, $endP "); } } else $db->query("select * from event order by ref DESC,re_step asc,c_date desc limit $startP, $endP"); $b=1; ?>
번호
제목
이름
조회수
등록일
row()) { for($d=2;$d<=$b;$d++){ if($b == $d){ $color="#f7f7f7"; } else{ $color="#ffffff"; } $d++; } ?>
re_level > 0){ $wid=$row->re_level; for($i=0;$i<=$wid;$i++){ echo "   "; } echo "└ c_idx."&t_i=".$i.">".$db_title=substring($row->c_title,0,30).".."; } else{ echo "c_idx."&t_i".$i.">".$db_title=substring($row->c_title,0,30).".."; } ?> c_date){ ?> c_name?> c_hit?> c_date?>
[ printPage($nPage);?>]