EmailArchive表：
id email_id to from 1 101 uk msm 2 102 uu avc 3 101 rk uk 4 103 xyz abc 5 104 xyz poi 6 104 abc xyz 7 101 xyz abc
现在在Yii我想要记录where email_id = 101
我使用下面的代码,但它不工作.
$id =101;
$criteria = new CDbCriteria();
$criteria->addCondition("email_id < :email_id");
$comments = EmailArchive::model()->findAll($criteria,array(':email_id' => $id,));
尝试：
$id =101;
$comments = EmailArchive::model()->findAll(
array("condition"=>"email_id = $id","order"=>"id"));
要么
$id =101;
$criteria = new CDbCriteria();
$criteria->addCondition("email_id=:email_id");
$criteria->params = array(':email_id' => $id);
$comments = EmailArchive::model()->findAll($criteria);
要么
$Criteria = new CDbCriteria(); $Criteria->condition = "email_id = $id"; $Products = Product::model()->findAll($Criteria);