search in two tables

[eluser]skunkbad[/eluser]
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();