MySQL query with temporary column's name in Yii

Question

I want to select only year from records ane make from this data assoc array

$wynik = $model_post::model() -> findAllBySql('SELECT DISTINCT YEAR(create_time) as rok FROM tbl_post');
for($i;$i<count($wynik);$i++)
{
    $rok[$wynik[$i]->rok]=$wynik[$i]->rok; 
}

but I got the exception

_Property "Post.rok" is not defined._

How can I make it correct?

laszlovl · Accepted Answer · 2015-05-04 10:52:14Z

2

If I remember correctly this should work in Yii1 as well: define a variable public $rok; in your model_post class, and it will automatically be populated when you use that query.

answered May 4, 2015 at 10:52

laszlovl

4912 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query with temporary column's name in Yii

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related