Welcome Guest, Not a member yet? Register   Sign In
Using join

[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

$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?

Messages In This Thread
Using join - by El Forum - 11-10-2008, 10:00 AM
Using join - by El Forum - 11-10-2008, 12:17 PM
Using join - by El Forum - 11-10-2008, 02:10 PM

Theme © iAndrew 2016 - Forum software by © MyBB