Welcome Guest, Not a member yet? Register   Sign In
join failed
#1

Hello,

I wonder why I cannot see the result of this after join.  If I comment out the join it does return a value.  I  do have wishlists table with user_id column and users table with id column.  I do have similar id.  I wonder why it does not return any value?



UserModel.php


    function enduser_table($data)
    {
        //merchants.id = orders.merchant_id

        $this->db->select('*');
        $this->db->from('users');
        $this->db->join('wishlists', 'wishlists.user_id = users.id');
        //$this->db->join('orders', 'orders.user_id = users.id');
        $this->db->where('id', $data);
        
        return $this->db->get()->result();

    }
" If I looks more intelligence please increase my reputation."
Reply


Messages In This Thread
join failed - by davy_yg - 05-23-2018, 08:47 PM
RE: join failed - by InsiteFX - 05-24-2018, 01:43 AM
RE: join failed - by davy_yg - 05-24-2018, 02:03 AM
RE: join failed - by nalletje - 05-24-2018, 06:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB