[fsb]

I couldn't find a satisfactory approach to loading data from a join table at the same time as loading the joined objects. In other words, A and B are joined via J and J has some pertinent data that should load automatically when an A object loads its Bs.

My first stab at a general solution is in the form of an extension to CActiveRecord. In the GitHub repository below it is in the context of a standard yiic webapp.

If you are interested, take a look at it. The README serves as an intro and points out where the extension, example models and unit tests lie. The extension itself has plenty of PHPdoc comments.

https://github.com/t.../Movie-Watchers

As a Yii beginner I would welcome comments.

If you think it's worth developing into something that others could use, please suggest what would have to change.