Welcome Guest, Not a member yet? Register   Sign In
Missing column data in join clause
#4

[eluser]nofearinc[/eluser]
I suppose it's due to ambiguity. I added a select() with required fields above the other join clauses:

Code:
$this->CI->db->select("users.user_id as user_id, username, password, group_name");

I'm able to extract the user_id now. The problem is that I have unpredictable number of fields in both tables so I need the 'select *' statement extracted. Is it possible to do "select users.user_id, *" or something like this in the statement in order to properly retrieve the ID?


Messages In This Thread
Missing column data in join clause - by El Forum - 12-14-2009, 07:17 PM
Missing column data in join clause - by El Forum - 12-14-2009, 07:36 PM
Missing column data in join clause - by El Forum - 12-15-2009, 02:56 AM
Missing column data in join clause - by El Forum - 12-15-2009, 03:50 AM
Missing column data in join clause - by El Forum - 12-15-2009, 04:05 AM
Missing column data in join clause - by El Forum - 12-15-2009, 04:10 AM
Missing column data in join clause - by El Forum - 12-15-2009, 10:40 AM
Missing column data in join clause - by El Forum - 12-15-2009, 11:09 AM



Theme © iAndrew 2016 - Forum software by © MyBB