Re: Condition with AND and ARRAY

If you execute the SQL above you will always get 0 results.

I think that what cake does by default (using IN) is exactly the thing you want, based on what you described (your hesitance on using UNION queries to get all results)

On Monday, March 9, 2015 at 8:54:09 PM UTC+1, michel martins wrote:

I need for all products that have tag_id = array item

SELECT * FROM produtos AS Produtos LEFT JOIN tags_produtos as TagsProdutos ON Produtos.id = TagsProdutos.produto_id  WHERE TagsProdutos.tag_id = 730 AND TagsProdutos.tag_id = 731 AND TagsProdutos.tag_id = 735

I have doubts whether I do the sql above or use UNION between multiple queries.

Table PRODUTOS

ID - PRODUTO

Table TAGS_PRODUTOS

ID - PRODUTO_ID - TAG_ID 

Table TAGS

ID - NAME

$tags = array('0'=>'730', '1'=>'731', '2'=>'735')

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.