UpdateCounters()

Archives Yii 1.0.x Discussions
1

http://www.yiiframework.com/doc/api/CActiveRecord#updateCounters-detail

Is it possible to decrement a counter?

2

Yes, use negative values.

3

Doesn’t work. Neither

updateCounters(array(‘voteCount’=>-1), ‘content=:userInput’, array(’:userInput’=>$model->content));

or

updateCounters(array($model->voteCount=>-1), ‘content=:userInput’, array(’:userInput’=>$model->content));

work

4

Ah, I see another part of my code was effecting this from changing the value.

5

I have just realised that when that code updates my counter, it updates my timestamp counter too. Is there a way to just update one table entry?

EDIT: it was my mysql settings. I always post too soon and then figure out my problem >.<