Jump to content
Larry Ullman's Book Forums

Help With Query Builder From Baby Yii-Er


Recommended Posts

I want to use the Query Builder as described in the yii manual: http://yiiframework.ru/doc/guide/en/database.query-builder

I struggle with the documentation as it does not specify exactly where to put things. I have an SQL query that I know works on my MySQL database. I have tried formatting it according to the directions at the link I pasted above. My problem is that I don't understand where to put it. I am testing it on a table called people. The model is call People too. Here is the query as I understand, translated in yii:



$user = Yii::app()->db->createCommand()

->select('Sum(IFNULL(yr1,0)) + IFNULL(yr2,0) + IFNULL(yr3,0) + IFNULL(yr4,0) + IFNULL(yr5,0) + IFNULL(yr6,0) + IFNULL(yr7,0) + IFNULL(yr8,0) + IFNULL(yr9,0) + IFNULL(yr10,0) AS Total ')


->group by('id');

Link to comment
Share on other sites


  • Create New...