sql 필터링 질문드립니다. 채택완료

</p>

<p><?php</p>

<p>$sub_menu = '200911';</p>

<p>include_once('./_common.php');</p>

<p> </p>

<p>auth_check($auth[$sub_menu], "r");</p>

<p>

 </p>

<p>$g5['title'] = '박람회문의목록';</p>

<p>include_once (G5_ADMIN_PATH.'/admin.head.php');</p>

<p> </p>

<p>$exhibitionList = array();</p>

<p>$exhibitionData = array();</p>

<p>$sql = "select e.e_no,  e.e_name, e_data from {$g5['exhibition_table']} e left join  {$g5['member_table']}  m on (e.e_mb_no=m.mb_no) ";</p>

<p>$sql_search = ' where (1) ';</p>

<p>if ($is_admin != 'super') {</p>

<p>    if($member['mb_level']==9)     $sql_search .= " and e.e_mb_no = '{$member['mb_no']}' ";</p>

<p>    if($member['mb_level']<9)     $sql_search .= " and e.e_mb_no = '{$member['mb_10']}'  and e.e_no= '{$member['mb_9']}'";</p>

<p>}</p>

<p>$result = sql_query($sql);</p>

<p>for ($i = 0; $row = sql_fetch_array($result); $i++) $exhibitionList[] = $row;</p>

<p> </p>

<p>foreach ( $exhibition_counsel_data_list  as $k=>$v) {</p>

<p>    $exhibitionData['is_use'][$k] = 1;</p>

<p>}</p>

<p> </p>

<p>if($subjectivity) {</p>

<p>    foreach ( $exhibitionList  as $k=>$v) {</p>

<p>        if($v['e_no']==$subjectivity) {</p>

<p>            $exhibitionData = unserialize($v['e_data']);</p>

<p>        }</p>

<p>    }</p>

<p>}</p>

<p>

 </p>

<p>$sql_common = " from {$g5['exhibition_counsel_table']} ec  left join  {$g5['exhibition_table']} e on (ec.e_no=e.e_no) left join  {$g5['member_table']}  m on (e.e_mb_no=m.mb_no)   ";</p>

<p>$sql_search = ' where (1) ';</p>

<p>if ($is_admin != 'super') {</p>

<p>    if($member['mb_level']==9)     $sql_search .= " and m.mb_no = '{$member['mb_no']}' ";</p>

<p>    if($member['mb_level']<9)     $sql_search .= " and m.mb_no = '{$member['mb_10']}'   and ec.e_no= '{$member['mb_9']}'";</p>

<p>}</p>

<p> </p>

<p>if($subjectivity)    $sql_search .= " and e.e_no = '{$subjectivity}' ";</p>

<p>// 테이블의 전체 레코드수만 얻음</p>

<p>$sql = " select count(*) as cnt " . $sql_common .  $sql_search;</p>

<p>$row = sql_fetch($sql);</p>

<p>$total_count = $row['cnt'];</p>

<p> </p>

<p>$rows = $config['cf_page_rows'];</p>

<p>$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산</p>

<p>if ($page < 1) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)</p>

<p>$from_record = ($page - 1) * $rows; // 시작 열을 구함</p>

<p> </p>

<p>$sql = "select ec.*, e.e_name, m.mb_name $sql_common $sql_search order by ec_regdate DESC limit $from_record, {$config['cf_page_rows']} ";</p>

<p> </p>

<p>$result = sql_query($sql);</p>

<p> </p>

<p>$qstr .= "&subjectivity=$subjectivity";</p>

<p>?></p>

<p>