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 [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
-~----------~----~----~----~------~----~------~--~---
