returns posts of a category via many-many-relation

post-categories.php

<?php

//table post (id, title)
//table category (id, name)
//table post_category (postId, categoryId)
 
//class Post extends CActiveRecord
public function relations()
{
  return array(
    'categories' => array(self::MANY_MANY, 'Category', 'tbl_post_category(postId, categoryId)')
  );
}
 
public function search($category)
{
  $criteria = new CDbCriteria;
 
  $criteria->with = array(
    'categories' => array(
      'condition' => 'categories.id = :categoryId',
      'params' => array(':categoryId' => $category->id),
      'together' => true
    )
  );
 
  return new CActiveDataProvider('Posts', array(
    'criteria' => $criteria,
  ));
}