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!