//분류가 같아야한다

        //wr_1~wr_7이 신청자와 같아선 안된다.

        //wr_1은 비어있으면 안된다.

        //wr_2 또는 wr_3가 추천인이여야한다

        //wr_2가 추천인 이면  

        //->wr_4와 wr_6 둘다 비어있거나                             =>wr_4로 저장

        //->wr_4는 값이 있더라도 wr_6는 비어있어야한다.              =>wr_6로 저장

        //wr_3가 추천인이면

        //->wr_5와 wr_7 둘다 비어있거나                             =>wr_5로 저장

        //->wr_5는 값이 있더라도 wr_7는 비어있어야한다.              =>wr_7로 저장

        //값은 오래된 순서로 하나 불러온다.

위의 조건을 다음과 같이 쿼리 작성했습니다.

 

select * from `g5_write_gold_tree`  

                    where 

                    `ca_name`="'.$result_v['ca_name'].'" 

                    and `wr_1` !="'.$result_v['wr_content'].'" 

                    and `wr_2` !="'.$result_v['wr_content'].'" 

                    and `wr_3` !="'.$result_v['wr_content'].'" 

                    and `wr_4` !="'.$result_v['wr_content'].'" 

                    and `wr_5` !="'.$result_v['wr_content'].'" 

                    and `wr_6` !="'.$result_v['wr_content'].'" 

                    and `wr_7` !="'.$result_v['wr_content'].'" 

                    and `wr_1` !=""

                    and

                    (  

                    `wr_2`="'.$mb_info1['mb_nick'].'" and (`wr_4` ="" and `wr_6`="" or `wr_4` !="" and `wr_6`="")

                    or 

                    `wr_3`="'.$mb_info1['mb_nick'].'" and (`wr_5` ="" and `wr_7`="" or `wr_5` !="" and `wr_6`="")

                    )

                    order by wr_datetime asc limit 1
검토 부탁드리고 더  좋은 방법이 있다면 알려주세요