permisi gan, ane lagi stuck sm permasalahan ane gan, tentang join table di codeigniter. Sebelumnya ane punya 2 tabel, info dan berita didalam database ane. untuk scriptnya seperrti ini

model

 function cariinfo($keyword) {

 $this->db->select('*';

$this->db->from('info';

$this->db->join('berita', 'info.id = berita.id';

$this->db->like('info.title', $keyword);

return $this->db->get()->result(); 

 }

controller

public function cariinfo(){

 $this->load->model('cariinfo_model';

 $keyword = $this->input->post('keyword';

 

 if($keyword != "")

 { 

 $data['query'] = $this->cariinfo_model->cariinfo($keyword);

 $this->load->view('backend/cariinfo_view',$data);

 }else{

 $data['query'] = "";

 $this->load->view('backend/cariinfo_view',$data);

 }

 }

view

<? echo form_open('login/cariinfo'; ?>



<h1 class="buatberitabaru">Masukan kata pencarian :</h1> <?php echo form_input(array('name' => 'keyword', 'class' => 'formnewsinput','value' => set_value('keyword')); ?>

<?php $i = 1 ?>

<?php 

 if($query != "")

 {

?>



<table class="tableberita" width="800" border="0" cellspacing="1" cellpadding="3">

 <tr>

 <td style="background-color:#E7E7E7; padding:5px;" width="29" align="center" valign="middle"><strong>ID</strong></td>

 <td style="background-color:#E7E7E7; padding:5px;" width="383" align="center" valign="middle"><strong>Judul Berita</strong></td>

 <td style="background-color:#E7E7E7; padding:5px;" width="210" align="center" valign="middle"><strong>Kategori</strong></td>

 <td style="background-color:#E7E7E7; padding:5px;" width="149" align="center" valign="middle"><strong>Keterangan</strong></td>

 </tr>

<?php

 foreach($query as $row)

 {

 ?>

 <tr>

 <td style="background-color:#eeeeee; padding:5px;" align="center" valign="middle"><?php echo $i++ ?></td>

 <td style="background-color:#eeeeee; padding:5px; padding-left:10px;" align="left" valign="middle"><?php echo $row->title; ?></td>

 <td style="background-color:#eeeeee; padding:5px;" align="center" valign="middle"><?php echo $row->kategori ?></td>

 <td style="background-color:#eeeeee; padding:5px; color:#256AC0;" align="center" valign="middle">| <?php echo anchor('login/editinfo/'.$row->id,'Edit';?> | <?php echo anchor('login/hapusberita/'.$row->id,'Hapus',array('onClick' => "return confirm('Apakah anda yakin ??'"));?> |</td>

 </tr>

 <?php

 }

 ?>

</table>

 <?php

 }

 ?>

<? echo form_close(); ?>

ane coba test script untuk mencari kata aaaaa ternayta tidak keluar datanya padahal ada, berarti tidak berfungi. Minta tolong gan bantu ane betulin script ini.. makasih sebelumnya