Welcome Guest, Not a member yet? Register   Sign In
join problem
#3

[eluser]Matalina[/eluser]
add 'left' as a third parameter to your join in active record and see if you get the same results.

I don't expect you will since both CI and mysql default to Inner join.

You also don't want to forget
Code:
$this->db->get();

$this->db->from('table_name') only specifies the table it doesn't actually run the query.


Messages In This Thread
join problem - by El Forum - 07-15-2008, 11:20 AM
join problem - by El Forum - 03-06-2012, 11:28 AM
join problem - by El Forum - 03-06-2012, 01:15 PM
join problem - by El Forum - 03-06-2012, 03:21 PM
join problem - by El Forum - 03-06-2012, 03:37 PM
join problem - by El Forum - 03-06-2012, 03:51 PM
join problem - by El Forum - 03-07-2012, 01:49 AM
join problem - by El Forum - 03-07-2012, 10:08 AM



Theme © iAndrew 2016 - Forum software by © MyBB