sql 필터링 질문드립니다.

<?php

$sub_menu = '200911';

include_once('./_common.php');

 

auth_check($auth[$sub_menu], "r");


 

$g5['title'] = '박람회문의목록';

include_once (G5_ADMIN_PATH.'/admin.head.php');

 

$exhibitionList = array();

$exhibitionData = array();

$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) ";

$sql_search = ' where (1) ';

if ($is_admin != 'super') {

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

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

}

$result = sql_query($sql);

for ($i = 0; $row = sql_fetch_array($result); $i++) $exhibitionList[] = $row;

 

foreach ( $exhibition_counsel_data_list  as $k=>$v) {

    $exhibitionData['is_use'][$k] = 1;

}

 

if($subjectivity) {

    foreach ( $exhibitionList  as $k=>$v) {

        if($v['e_no']==$subjectivity) {

            $exhibitionData = unserialize($v['e_data']);

        }

    }

}


 

$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)   ";

$sql_search = ' where (1) ';

if ($is_admin != 'super') {

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

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

}

 

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

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

$sql = " select count(*) as cnt " . $sql_common .  $sql_search;

$row = sql_fetch($sql);

$total_count = $row['cnt'];

 

$rows = $config['cf_page_rows'];

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

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

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

 

$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']} ";

 

$result = sql_query($sql);

 

$qstr .= "&subjectivity=$subjectivity";

?>