views:

127

answers:

0

Hello all,

In CakePHP, I have this code:

$data = $this->paginate('Model', array("MATCH(Model.colA) AGAINST('$q' IN BOOLEAN MODE)"));

And I am trying to increment by 1 the values of Model.colB for the rows retrieved (10 per page). So I'm guessing it's something like:

$data = $this->paginate('Model', array("MATCH(Model.colA) AGAINST('$q' IN BOOLEAN MODE) SET(Model.colB=Model.colB+1)"));

But that doesn't work. Anyone have any ideas? Is it possible to do this in one query?

Thanks for the help!