Searching in different tables

Yii 1.1 General Discussion
1

How can I search in different tables?




$criteria = new CDbCriteria;

$criteria->condition = implode(' AND ', $condition);

$criteria->params = $params;

$criteria->width = array('authorlink', 'items');

$criteria->addSearchCondition('authorlink.TITLE', '%' . $searchstring->search_string . '%', true);

$items = Item::model()->findAll($criteria);

But that doesn’t work :(

2

Use the join property

3

You have a typo in your with line:

should be:


$criteria->with = array('authorlink', 'items')