Yes, thats my biggest issue, I don't know if there is a way within Cake to define multiple array values for 'Question.content LIKE'
I've tried building it like this, however the SQL query built off of this array isn't correct: $term = $this->data['Question']['searchTerm']; $splitTerms = explode(" ",$term); foreach($splitTerms as $splitTerm): $conditions['conditions']['OR'] ['Question.content LIKE'][$i]= ("% $splitTerm%"); $i++; endforeach; $this->set('questions',$this->Question->find('all',$conditions)); On Nov 5, 2:38 pm, teknoid <[EMAIL PROTECTED]> wrote: > Seems like you are overriding your condition each time... > > On Nov 5, 1:49 pm, Nick <[EMAIL PROTECTED]> wrote: > > > I'm hoping someone can help. I'm fairly new to CakePHP but am > > thoroughly enjoying coding with it. > > > Basically I've got a field within a table that contains my content. > > I'm trying to grab the search terms from a single input, explode them > > and search the content section for each term individually. > > > I'm doing something along these lines: > > > $term = $this->data['Question']['searchTerm']; > > $splitTerms = explode(" ",$term); > > foreach($splitTerms as $splitTerm): > > > > $conditions['conditions']['OR']['Question.content LIKE'] = array("% > > $splitTerm%"); > > endforeach; > > $this->set('questions',$this->Question->find('all',$conditions)); > > > My dilemma is basically in setting the conditions... because > > 'Question.content LIKE' can only contain one value, I can't build an > > array within my foreach loop that I can then pass to the find method > > to build a full SQL query. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---