[eluser]Marcelo Kanzaki[/eluser]
Hello everybody,
here is the situation:
I have
3 tables in my database -
Events, Consultants and
Locations.
To generate an event, i need pick one (or more) consultant from the Consultants table along with a location from the Locations table.
To handle the one_to_many relationship between Events and Consultants i've created a
fourth table called
Consultants_Events, wich has the event_id and the consultant_id that allows me to add more than one consultant per event.
Quote:***** My question is how do i list Events now? *****
I could simply use
Code:
$this->db->get('events');
$this->db->join('locations', 'locations.id = events.location_id');
But what about the consultants? Since there can be more than one per event, how do i list them?