웅파님 매번 답변 감사 합니다.

    function kcWorkBookSWLists($iwmIdx, $iamIdx, $qarea)
    {
        $this->db->select('iw.*, ia.qAnswer as answer, ia.qFilename as ansfilename, ia.qTypeCode, ia.qCorrectScore');
        $this->db->select('dw.uFileName as dw_filename, dw.uJimoon as dw_jimoon, iqm.qQuestion as dcontent'); //디렉션
        $this->db->select('iq.qContent as qcontent, qw.uFileName as qw_filename, qw.uJimoon as qw_jimoon, qi.uFileName as qi_filename'); //문항
        $this->db->select('ic.code as qtcode, iqm.qJimoon as qmjimoon, iq.qCorrect as qcorrect, iq.qcorrectpoint');
        $this->db->select('iq.qWordCount, ia.spSubScore, ia.wrSubScore, icclass.code as classCode, iqm.qClasss');
        $this->db->select($iamIdx.' as iamIdx', false);
       
        $this->db->from('ibtworkbook iw');
        $this->db->join('ibtanswer ia', 'ia.qNo=iw.wbNo and ia.iamIdx='.$iamIdx, 'LEFT');
        $this->db->join('ibtquestion iq', 'iq.iqmIdx=iw.iqmIdx and iq.qNo=iw.qNo', 'LEFT');
        $this->db->join('ibtquestionmaster iqm', 'iqm.iqmIdx=iq.iqmIdx', false);
        $this->db->join('ibtquestiontype iqt', 'iqt.iqtIdx=iqm.iqtIdx', false);
        $this->db->join('ibtcode ic', 'ic.icIdx=iqt.qType', 'LEFT');
        $this->db->join('ibtwaves dw', 'dw.iwIdx=iqm.diwIdx', 'LEFT');
        $this->db->join('ibtwaves qw', 'qw.iwIdx=iq.iwIdx', 'LEFT');
        $this->db->join('ibtimages qi', 'qi.iiIdx=iq.iiIdx', 'LEFT');
        $this->db->join('ibtcode icclass', 'icclass.icIdx=iqm.qClasss', 'LEFT');
        $this->db->where('iw.iwmIdx', $iwmIdx);
        $this->db->where('iw.qArea', $qarea);

        $this->db->order_by('iw.wbNo ASC');
  $rlt = $this->db->get();
  // echo $this->db->last_query() . "<BR><BR>";

        return $rlt->result_array();
    }
 

라스트쿼리한것을 직접 sql 문으로 돌려보면 첨부와 같이 4 개의 row 가 나옵니다. 이중에 박스부분은 var_dump 로 찍어보면 안나옵니다.

dump 로 찍으면 아래와 같습니다.
Array
(
    [0] => Array
        ( ...
            [ansfilename] =>  미 출력되는 부분
            [iamIdx] => 2018
        )

    [1] => Array
        (...
            [ansfilename] => 미출력되는 부분
            [iamIdx] => 2018
        )

    [2] => Array
        (...
            [ansfilename] => michigansteph013_u-neat_KY12J2000035_35.mp3
            [iamIdx] => 2018
        )

    [3] => Array
        (...
            [ansfilename] => michigansteph013_u-neat_KY12J2000035_36.mp3
            [iamIdx] => 2018
        )

)

특별히 $this->db->join('ibtquestionmaster iqm', 'iqm.iqmIdx=iq.iqmIdx', false); 이렇게 하신 이유가 있을까요?

join의 세번째 파라미터에 false는 없습니다. 세번째 파라미터를 빼고 해보세요.

웅파님 빠른 답변 정말 감사 합니다. 늘 행복하세요.