search in two tables

[eluser]anyamanggar[/eluser]
[quote author="skunkbad" date="1343010735"]This is documented @ http://ellislab.com/codeigniter/user-gui...ecord.html :

Code:

$this->db->select('*');
$this->db->from('info');
$this->db->join('berita', 'info.id = berita.id');
$this->db->like('info.title',$keyword);
$query = $this->db->get();

[/quote]

i try your code, the results is didnt show,

Code:

function cariinfo($keyword) {
$this->db->select('*');
$this->db->from('info');
$this->db->join('berita', 'info.id = berita.id');
$this->db->like('info.title',$keyword);
$query = $this->db->get();
}

but if i try like this (search in one table) its work, the result for what i search its show

Code:

function cariinfo($keyword) {
  
  $this->db->like('title',$keyword);
  return $this->db->get('info')->result();
}