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);