"; $searchtype = $_REQUEST['searchtype']; $searchword = $_REQUEST['searchword']; $dt_start = $_REQUEST['dt_start']; $dt_end = $_REQUEST['dt_end']; if($searchword != ""){ if($searchtype=="" || $searchtype==null){ $sql = $sql. " and (nm_name like '$searchword%' or nm_email like '$searchword%') "; }else{ $sql = $sql. " and $searchtype like '$searchword%'"; } } if($dt_start != "" && $dt_end != ""){ $sql = $sql. " and dt_insert between '$dt_start' and '$dt_end' "; } // echo $sql; $totalrows = @mysql_result(mysql_query("select count(*) from sa_master $sql"),0,0); ?>

SA탈퇴 관리

▶ 회원검색

검색어

0) { $r = mysqli_query($connect, "SELECT *, getCode('sa_master','ds_company_bp',ds_company_bp) as nm_company_bp, getCode('sa_master','ds_branch',ds_branch) as nm_branch FROM sa_master $sql ORDER BY cd_user desc LIMIT $pagestartpoint,$PageSize"); $i=1; while($col = mysqli_fetch_array($r)) { $tmpNum =$totalrows-($PageSize*($PageNo-1)); $no = ($tmpNum - $i)+1; ?>

번호	아이디	탈퇴일

데이터가 존재 하지 않습니다.