Error on trying to join tables |
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) I tear my hair I will not have any more :-) PHP Code: $query = $this->db->select('cl.*, ct.name') https://www.codeigniter.com/userguide3/d...ilder.html
CodeIgniter Users Guide
See: The Query Builder join method. What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
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').... |
Welcome Guest, Not a member yet? Register Sign In |