Thank you thank you very very much appreciated
brian-9 wrote:
>
>
> My bad. Try this:
>
> $this->Recipe->find('all', array('conditions' => array(
> 'OR' => array(
> 'Recipe.name LIKE' => '%' . $item . '%',
> 'Recipe.caption LIKE' => '%' . $item . '%'
> )
> ),
> 'order' => 'Recipe.name',
> 'recursive' => 1
> )
> );
>
> Aso, set debug to 2 and look at the SELECT Cake is generating.
>
> On Thu, Feb 5, 2009 at 12:17 PM, monirr444 <[email protected]> wrote:
>>
>>
>>
>>
>>
>> function search($item = null) {
>> $item = $this->params['url']['q'];
>> $recipes = $this->Recipe->find('all', array('conditions' => array(
>> 'OR' =>array(
>> array('Recipe.name LIKE' => '%' . $item . '%',
>> array('Recipe.caption LIKE' => '%' . $item . '%')))),
>>
>> 'order' =>
>> 'Recipe.name',
>>
>> 'recursive' => 1,
>> ));
>>
>> i tried put wont give the results as u can see above
>>
>> when i put individual it work lets say Recipe.ingredients LIKE
>> its show the the result good but only ingredients but i want both
>>
>>
>> thank you very much appreciated
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> brian-9 wrote:
>>>
>>>
>>> try
>>>
>>> 'conditions' => array(
>>> 'OR' => array(
>>> array('Recipe.name LIKE' => '%' . $item . '%'),
>>> array('Recipe.ingredients LIKE' => '%' . $item . '%')
>>> )
>>> )
>>>
>>> On Thu, Feb 5, 2009 at 10:34 AM, monirr444 <[email protected]> wrote:
>>>>
>>>>
>>>> function search($item = null) {
>>>> $item = $this->params['url']['q'];
>>>> $recipes = $this->Recipe->find('all', array('conditions'
>>>> =>
>>>> array('Recipe.name LIKE' => '%' . $item . '%'),
>>>> 'order' =>
>>>> 'Recipe.name',
>>>> 'recursive' => 1,
>>>> ));
>>>>
>>>> //var_dump($recipes);
>>>>
>>>> if (!$item) {
>>>> $this->Session->setFlash(__('No Search Items
>>>> Found',
>>>> true));
>>>> $this->redirect(array('action'=>'index'));
>>>> }
>>>>
>>>> $this->set('search', $recipes);
>>>> }
>>>>
>>>> this is my public website search when ever i search it give me results
>>>> by
>>>> name
>>>> how to put 2 condations so it search by name and ingredients
>>>> i used "OR" but didnt work maybe i used it worng
>>>> like this
>>>>
>>>> "array('Recipe.name LIKE' => '%' . $item . '%'), "
>>>> "array('Recipe.ingredients LIKE' => '%' . $item . '%'), "
>>>> i wanna 2 these whenever i search by name and ingredients it should
>>>> give
>>>> both results
>>>> i looked the cake book i coudnt find any
>>>>
>>>> thank you so much
>>>> --
>>>> View this message in context:
>>>> http://n2.nabble.com/Help-with-Complex-Find-Conditions-tp2275441p2275441.html
>>>> Sent from the CakePHP mailing list archive at Nabble.com.
>>>>
>>>>
>>>> >
>>>>
>>>
>>> >
>>>
>>>
>>
>> --
>> View this message in context:
>> http://n2.nabble.com/Help-with-Complex-Find-Conditions-tp2275441p2276013.html
>> Sent from the CakePHP mailing list archive at Nabble.com.
>>
>>
>> >
>>
>
> >
>
>
--
View this message in context:
http://n2.nabble.com/Help-with-Complex-Find-Conditions-tp2275441p2276368.html
Sent from the CakePHP mailing list archive at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
