관리자 point_list 에서 회원이름검색추가 채택완료

// $sql_common = " from {$g5['point_table']} po";
$sql_common = " from {$g5['point_table']} po left outer join {$g5['member_table']} mb on mb.mb_id = po.mb_id";

switch ($sfl) {
        // case 'mb_id':
        //     $sql_search .= " (po.{$sfl} = '{$stx}') ";
        //     break;
        // default:
        //     $sql_search .= " ({$sfl} like '%{$stx}%') ";
        //     break;
        case 'mb_id':
            $sql_search .= " (po.{$sfl} = '{$stx}') ";
            break;
        case 'mb_name':
            $sql_search .= " (mb.{$sfl} = '{$stx}') ";
            break;
        default:
            $sql_search .= " (po.{$sfl} like '%{$stx}%') ";
            break;
    }

if (!$sst) {
    // $sst  = "po_id";
    $sst  = "po.po_id";
    $sod = "desc";
}

$sql = " select po.*, mb.mb_name, mb.mb_nick, mb.mb_email, mb.mb_homepage, mb.mb_point
            {$sql_common}
            -- LEFT JOIN {$g5['member_table']} mb ON po.mb_id = mb.mb_id 
            {$sql_search}
            {$sql_order}
            limit {$from_record}, {$rows} ";

<select name="sfl" id="sfl">

        <option value="mb_id" <?php echo get_selected($sfl, "mb_id"); ?>>회원아이디</option>

        <option value="mb_name"<?php echo get_selected($sfl, "mb_name"); ?>>회원이름</option>

        <option value="po_content" <?php echo get_selected($sfl, "po_content"); ?>>내용</option>

    </select>