Welcome Guest, Not a member yet? Register   Sign In
Problem with multiple joins
#6

[eluser]nzmike[/eluser]
If you've named the primary key in the events table event_id you might have a problem because now you're trying to select from two tables that share a column name. As überfuzz has mentioned it would be useful to see the MySQL string. Try using

Code:
$this->db->last_query();


Messages In This Thread
Problem with multiple joins - by El Forum - 09-08-2009, 10:34 PM
Problem with multiple joins - by El Forum - 09-08-2009, 10:40 PM
Problem with multiple joins - by El Forum - 09-08-2009, 11:02 PM
Problem with multiple joins - by El Forum - 09-08-2009, 11:08 PM
Problem with multiple joins - by El Forum - 09-09-2009, 01:18 AM
Problem with multiple joins - by El Forum - 09-09-2009, 02:44 AM



Theme © iAndrew 2016 - Forum software by © MyBB