search in codeigniter

You need to use a join to join the two tables.

You could do something like:

PHP Code:

$this->db->from('invoice');
$this->db->join('customer', 'invoive.cusid  = customer.cid');
$this->db->like('cusname ', $search); 


Since a customer can have more than one invoice, I would suggest you check the query with something like:

PHP Code:

$query = $this->db->get();
if ($query->num_rows() > 0)
{
   $results = $query->result_array();
}
else
{
   $results = FALSE;
} 


There are some great help documents on all this:
http://www.codeigniter.com/user_guide/da...eries.html
http://www.codeigniter.com/user_guide/da...sults.html

Best wishes,

Paul.