naigo 2011-07-07 10:24:08 4782次浏览 1条回复 0 0 0
const SQL_COUNT_OPERATORS = "select * FROM sp_operator, sp_department, sp_provider WHERE sp_operator.department_id = sp_department.id AND sp_department.provider_id = sp_provider.id AND sp_provider.id=:pid";

Operator::model()->countBySql(self::SQL_COUNT_OPERATORS, array(':pid'=>Yii::app()->user->id));

在数据库运行sql语句返回2条记录,运行程序却返回了最大id值?我用的1.1.6版本的Yii

您需要登录后才可以回复。登录 | 立即注册