如何将此sql语句转换为yii格式以构建模型?
SELECT DISTINCT agency_id, university_id
FROM `tbl_universityagency` where agency_id=1
像这样我缺少什么?,
$criteria = new CDbCriteria();
$criteria->distinct=true;
$criteria->condition = "agency_id=".$result->agency_id ;
$modal=Universityagency::model()->find($criteria);
$criteria = new CDbCriteria();
$criteria->distinct=true;
$criteria->condition = "agency_id=".$result->agency_id ;
$criteria->select = 'id, agency_id, university_id';
$modal=Universityagency::model()->find($criteria);
应该产生查询:
SELECT DISTINCT id,agency_id, university_id FROM `tbl_universityagency` where agency_id=1 LIMIT 1
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句