Multiple table load

[eluser]sharea[/eluser]
[quote author="noctrum" date="1265162989"]

Code:

function validate_add_cart_item(){
        function validate_add_cart_item(){

Is this a typo?[/quote]

My bad. Only done it this way in the post not the document.

[eluser]sharea[/eluser]
Does any of you have an idea on how to solve the problem?

[eluser]chazy (aldever calvo)[/eluser]

Code:

$q = "SELECT A.user_id, A.uname, A.user_type_id, D.lname, D.fname, D.email, T.user_type_name FROM user as A LEFT JOIN user_details as D ON A.user_id = D.user_det_id;

        $query = $this->db->query($q);
                  
        return $query->result();//array of user record as objects
    }

this is what i did with mine... i joined two tables using the sql query... you may also join 2 or more tables with that..