게시판리스트에서 파일 첩부된 표기 할려고 합니다.

아래부분 left join 추가시 notice,files 데이블이 조인되어 게시무중에 파일첨부된 리스트목록에 아이콘과 결과값이 나오는데.

전체게시물에 번호값이나 찍히지 않나네..

결과쿼리

SELECT * FROM `notice` LEFT JOIN `files` ON `notice`.`idx` = `files`.`idx` WHERE `category` != 'A' ORDER BY `notice`.`idx` desc LIMIT 20

views

foreach($bbs as $bbsList) {

<tr><td height="25" align="center"><?php echo $bbsList->idx?></td>

<td><?php echo $bbsList->category ?></td>    

<td class="write_subject"><a href="javascript:bbs_view('<?php echo $bbsList->idx?>')" class="list_td"><?php echo $bbsList->title ?>[<?php echo $comment_cnt?>]</a> </td>    

<td><?php echo $bbsList->wrname?></td>

<td><?php echo date('Y-m-d', strtotime($bbsList->wdate));?><?//echo $my_date?></td>    

<td><?php    if (($bbsList->filename) == "") {    } else {     echo " <img src=/home/images/icon_file.gif style=margin-top:4px;>";    }     ?><?php echo $bbslist['filename']?></td>

<td><?php echo $bbsList->hit?></td>

<td><a href="javascript:bbs_edit('<?php echo $bbsList->idx?>')">수정</a> / <a href="javascript:bbs_del('<?php echo $bbsList->idx?>')">삭제</a></td>    </tr>

}

controllers

$this->load->view('head');

$this->load->library('pagination');

$NoticeList = $this->bbs_model->NoticeList_data($idx);

$data = array ( 

'NoticeList' => $NoticeList

);

$data['comment_count'] = $this->bbs_model->comment_total();  

$data['total_count'] = $this->bbs_model->get_total();  

$bbs_data = $this->bbs_model->bbs_data();  

$config['base_url'] = base_url().'/notice/index';  

$config['total_rows'] = $bbs_data;  $config['per_page'] = 20;

$from = $this->uri->segment(3);  $this->pagination->initialize($config);

$data['bbs'] = $this->bbs_model->data($config['per_page'],$from);

$this->load->view('notice_list', $data); 

$this->load->view('footer');

models

function data($number,$offset) {

$this->db->get_where('notice', 'idx');  $this->db->where(array('category !=' => 'A')); 

$this->db->join('files', 'notice.idx = files.idx', 'left');

$this->db->order_by('notice.idx desc');  return $query = $this->db->get('notice',$number,$offset)->result();