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,));
尝试:
原文链接:https://www.f2er.com/php/138289.html$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);