criteria 报错




$criteria = new CDbCriteria;

$criteria->order = 'order DESC';



只能填id,填其他字段名时就报错: SELECT * FROM menu t ORDER BY order DESC

怎么回事?

你的order字段是关键字 换成’order DESC’