Many-to-Many Relationships & Active Record Class

Many-to-Many Relationships & Active Record Class

El Forum
Unregistered

#11

11-28-2007, 11:49 AM

[eluser]gdgray[/eluser]
This should take care of missing links ...

SELECT news.*, newscat.*
FROM ci_news news
LEFT OUTER JOIN ci_news_to_categories news2cat ON news.id = news2cat.news_id
LEFT OUTER JOIN ci_news_categories newscat ON newscat.id = news2cat.category_id

greg

Messages In This Thread

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 09:00 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 10:07 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 10:16 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 11:32 PM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 02:44 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 03:00 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 08:41 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 09:00 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 10:07 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 11:02 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 11:49 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 12:33 PM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 08:46 PM

Many-to-Many Relationships & Active Record Class - by El Forum - 12-05-2007, 11:02 PM