adding both equal and not equal conditions in Yii

Question

$id = Yii::app()->user->getState("logId");
$name = Yii::app()->user->getState("username"); 

$dataProvider=Disnotification::model->findAllByAttributes(array('logID' => $id,'username'!=$name));

How can I find records which equals to $id but not equals to $name?

Answer 1

$criteria=new CDbCriteria;
$criteria->condition = "username != '$name' AND logID = :id";
$criteria->params = array (
    ':id' => $id,
);
$dataProvider = Disnotification::model()->findAll( $criteria );