Oh, my bad. I must have typed it incorrectly. They should all be $conditions; I'd rather do it in an array because I have a lot of different conditions/fields that can go into the array. Is it possible to do MATCHES in an array?
On May 13, 7:20 pm, brian <[email protected]> wrote: > You mention both $conditions & $criteria so it's a bit difficult to > say for sure. But that last bit would probably work better as one > complete string. > > 'MATCH(SearchIndex.data) AGAINST(\'' > . $this->params['named']['search'] > . '\') IN BOOLEAN MODE)'; > > > > On Wed, May 13, 2009 at 6:37 PM, Kyle Decot <[email protected]> wrote: > > > I am attempting to construct my array but am having some problems w/ > > the $conditions array. I am doing something like: > > > $conditions = array("Model.approved"=>1); > > > if($something == $something_else) > > $conditions['Model.something'] = 1; > > > if(!empty($search)) { > > > $criteria["MATCH(SearchIndex.data) "] = "AGAINST(" . $this->params > > ['named']['search'] . "') IN BOOLEAN MODE)"; > > > } > > > This is not making a valid mysql query. It's putting an equals sign > > right before the AGAINST part. How should I do this? Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
