public function GetRateForDate($id, $date) { $criteria = new CDbCriteria(); $criteria->select = 'value'; $criteria->addColumnCondition(array('currency_id' => $id)); $criteria->addColumnCondition(array('date' => $date)); $model = Currates::model(); $value = $model->commandBuilder->createFindCommand($model->tableName(), $criteria)->queryScalar(); return $value; }