쿼리질문입니다 채택완료

$recommend = "master";

        $query01 = sql_fetch("SELECT * FROM member WHERE mb_id = '$recommend' and mb_package != ''");

        $recommend2 = $query01["mb_recommend"];

       

        $query02 = sql_fetch("SELECT * FROM member WHERE mb_id = '$recommend2' and mb_package != ''");

        $recommend3 = $query02["mb_recommend"];

 

        $query03 = sql_fetch("SELECT * FROM member WHERE mb_id = '$recommend3'and mb_package != ''");

        $recommend4 = $query03["mb_recommend"];

       

        $query04 = sql_fetch("SELECT * FROM member WHERE mb_id = '$recommend4'and mb_package != ''");

        $recommend5 = $query04["mb_recommend"];

       

        $query05 = sql_fetch("SELECT * FROM member WHERE mb_id = '$recommend5'and mb_package != ''");

 

        if($query01["mb_id"] != ""){

            $maching01 = $query01["mb_id"];

        } else if ($query01["mb_id"] == "" && $query02["mb_id"] != ""){

            $maching01 = $query02["mb_id"];

        } else if ($query01["mb_id"] == "" && $query02["mb_id"] == "" && $query03["mb_id"] != ""){

            $maching01 = $query03["mb_id"];

        } else if ($query01["mb_id"] == "" && $query02["mb_id"] == "" && $query03["mb_id"] == "" && $query04["mb_id"] != ""){

            $maching01 = $query04["mb_id"];

        } else if ($query01["mb_id"] == "" && $query02["mb_id"] == "" && $query03["mb_id"] == "" && $query04["mb_id"] == "" && $query05["mb_id"] != ""){

            $maching01 = $query05["mb_id"];

        }