CodeIgniter Forums

Full Version: Active Record - many-to-many relation with fields in the join table? (no ORM, just CI)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

I have 2 tables and 1 join table.
And the problem is that I have some extra fields in the join table, and i can't figure out how to get them xD

Here are the tables:




I need to get a list of sponsors in a single event, and get the value, maxvalue and qr_string from the join table too. I don't need any info from the event table (not yet anyways xD)

Here is "where I am" now xD

$this->db->select('id_sponsor, name, description, img_link, url, id_event, value, maxvalue, qr_string');
$this->db->join('gj_sponsors', 'gj_sponsors.id_sponsor = gj_join_events_sponsors.id_sponsor');
$this->db->where(array('gj_join_events_sponsors.id_event' => $event_id));

$query = $this->db->get();

$row = $query->result();

I get this error:

Quote:A Database Error Occurred

Error Number: 1052

Column 'id_sponsor' in field list is ambiguous

SELECT `id_sponsor`, `name`, `description`, `img_link`, `url`, `id_event`, `value`, `maxvalue`, `qr_string` FROM (`gj_sponsors`) JOIN `gj_join_events_sponsors` ON `gj_join_events_sponsors`.`id_sponsor` = `gj_sponsors`.`id_sponsor` WHERE `gj_join_events_sponsors`.`id_event` = '8'

Filename: C:\........\system\database\DB_driver.php

Line Number: 330

Really hope someone can help xD
And please no "just use an ORM" or similar Wink This project I'm making without, I'm looking into it for my next project ^^