검색 질문 드립니다.

if ($member[mb_level] >= $board[bo_write_level]) {
    if (!$sst) {
        $sst = "wr_id";
        $sod = "desc";
    }
    $sql_common = " from $table_member ";
    $sql_search = " where (1) ";

    if ($stx) {
        $sql_search .= " and ( ";

        switch ($sfl) {
            case "wr_list" :
                $sql_search .= " ($sfl = '$stx') ";
                break;
            case "wr_size" :
                $sql_search .= " ($sfl = '$stx') ";
                break;
            case "wr_like" :
                $sql_search .= " ($sfl = '$stx') ";
                break;
            case "wr_name" :
                $sql_search .= " ($sfl = '$stx') ";
                break;
            default :
                $sql_search .= " ($sfl like '%$stx%') ";
                break;
        }
        $sql_search .= " ) ";
    }

    $sql_order = " order by $sst $sod ";
    $sql = " select count(*) as cnt
            $sql_common
            $sql_search
            $sql_order ";
    $row = sql_fetch($sql);
    $total_count = $row[cnt];
    $rows = 15;
    $total_page  = ceil($total_count / $rows);
    if (!$page) $page = 1;
    $from_record = ($page - 1) * $rows;
    $sql = " select *
            $sql_common
            $sql_search
            $sql_order
            limit $from_record, $rows ";
    $result = sql_query($sql);
}