CodeIgniter Forums

Full Version: Error on trying to join tables
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all,

Need help, I've tried a lot of things but it doesn't work.
An image is better to understand, here my two tables
http://www.hostingpics.net/viewer.php?id...121741.png

So for a simple example, I would like to get all columns from 'client' + column 'name' from 'contact'


My actual function is :
PHP Code:
public function get_client($client_id)
 
     {

 
           $this->db->where('client_id'$client_id);
 
           $query $this->db->get('client');
 
           if($query->num_rows()!==0)
 
           {
 
                 return $query->result();
 
           }
 
           else
            
{
 
                 return FALSE;
 
           }
 
     
This function works and I would like to add the column 'name'

I tear my hair I will not have any more :-)
PHP Code:
$query $this->db->select('cl.*, ct.name')
->
from('client cl')
->
join('contact ct','cl.client_id = ct.client_id')
->
where('cl.client_id'$client_id)
->
get(); 

https://www.codeigniter.com/userguide3/d...ilder.html
CodeIgniter Users Guide

See: The Query Builder join method.
That's what I've done but I was writing :
$this->db...
$this->db...

probably something wrong in the code, but now with your code it's working.
thx u

and I read the doc ^^

P.S. : I thing I know why ! I specified get('client')....