php - Incorrect rows returned by webshop filter -

I have a table of products with field id, name, URL, brand, then I have a field called product_filter Field ID, PRODUCT_ID, TYPE, VALUE

Assume that I have a table of the following products

1 | Product 1 | Product-1 Brand 1
2 | Product 2 | Product -2 Brand 2
3 | Product 3 | Product -3 Brand 1

and product_filter table

1 | 1 | Content | Wool | 2 | 1 | Content | Cotton
3 | 2 | Content | Cotton | 4 | 3 | Content | Wool 5 1 | Weather | Decline | 5 | 2 | Weather | Decline | 5 | 1 | Weather |

Content: wool, cotton season: fall

P> My result is 1 product (content and The right season is both) and the product is 2 (1 material and right season).

I tried to join the

  DISTINCT (shop_product.product_number), `shop_product`.`color_count`,` shop_product`.`category_id` , `Shop_product`.in_stock`,` shop_product`.`url_image`, `shop_product_description`. * From ( `shop_product`) Join combination based on shop_product`.`id` =` `shop_product_description`.`product_id` shop_category_description` on` `shop_product_description`` shop_product`.`category_id` = `shop_category_description`.`category_id` insider `Join Pr` shop_filters` shop_product`.`id` =` shop_filters`.`product_id` Jhan` shop_product`.`status` = 1 and `shop_product_description`.`language_id` = '1' and` shop_category_description`.` language_id` = '1' and ((Shop_filters.type = '1' and shop_filte rs.keyword = 'cotton') or (shop_filters.type = '1' and shop_filters.keyword = 'wool')) and (shop_filters.type = '2' and shop_filters.keyword = 'degradation') Order by shop_product` `Url_image` asc,` shop_product_description` .`name` name LIMIT 36  

I used separate to get 1 oyour product back (the product is due to be both the content).

But by the time I change

  ((shop_filters.type = '1' and shop_filters.keyword = 'cotton'), I have no results Or (shop_filters.type = '1' and shop_filters keyword = 'wool')) and (shop_filters.type = '2' and shop_filters.keyword = 'fall')  

to

  ((shop_filters. type = '1' and shop_filters.keyword = 'cotton') or (shop_filters.type = '1' and shop_filters.keyword = 'wool')) or (shop_filters.type = '2' and shop_filters.keyword = 'degradation')  

Although my results are products of cotton or wool or fall, if there is any suggestion, please consider ... < / P>

You must match the filter several times against the table, the easiest to check against each filter.

  DISTINCT (shop_product.product_number), shop_product.color_count, shop_product.category_id, shop_product.in_stock, shop_product.url_image, shop_product_description. * (Shop_product) joins shop_product_idcription on shop_product.id = shop_product_description.product_id JOIN shop_product.cager_id at store_product.category_id = shop_category_description.category_id join INNER shop_filters at sf1 shop_product.id = sf1.product_id INNER included shop_filters at sf2 shop_product Kid = Sf2kproduct_id where shop_product.status = 1 and shop_product_description.language_id = '1' and shop_category_description.language_id = '1' and ((sf1.type = '1' and shop_filters.sf1 = 'cotton') or (Sfl Ktype = 'L' and sf1.keyword = 'wool')) and (sf2.type = '2' and sf2.keyword = 'fall') shop_product.url_image by ORDER asc, shop_product_description.name desc LIMIT 36 < / Code>    
 


  















Popular Posts




Change uuid to integer id in mongodb - sails.js -



    Then I have changed cells.js database on mangodeb server with local discount and all my ids have changed to a uuid id . General ID is very easy and cleaner. How can I change my ID again as integer ID?   What are the benefits of using btw UUID? And how do I request an update with that long ID?    {"name": "mutton", "id": "544a7968101ca2903974cdc1", "createdAt": "2014-10-24T16: 08: 08.052Z", "UpdateAut": "2014-10-24T 16: 08: 08.052Z"}       This " Normal "method that creates MongoDB id, is a combination of timestamp, machine identifier, process id and random values.   From the MongoDB site:  "Documents stored in a collection require a unique _id field which acts as the primary key. Since ObjectIds are small, most likely is unique, and Fast to generate "    The primary key and probably some other data are related to them.   If you want to keep the id like 1,2,3,4,5 ... you have to set u...






openstack - How to install packages in cirros OS -



    How to install a package in Cyrus image?   I do not have any installer available in the Siros image that comes with devstack installation.      As @Harik Krishnan commented, cirros does not include a package manager in cirros More useful for the fact that the clouds are working correctly, that VMs are being started properly and things like network, security groups and key pairs are working relatively well.   If you are a package manager Want a Linux VM with, you should see a different distribution . Ubuntu is a good place to start the cloud image -     






python - Explanation of pysftp.Connection.walktree() parameters -



    I've just started using Python of Python and I'm confused about how to do this  Walktree  function   I have found some code (found) that helps me better understand how my parameters look like    Def walktree (self, remotepath, fcallback, dcallback, ucallback, recurse = True): '' 'recursive down, depth first, directory tree contained in RemotePep, each regular file, Call for thoughtful callback function for directory and unknown file type. : Param str remotepath: The route of the remote directory to descend, '.' To get started: Atri: `.pwd`: Ultimate Liable Fiscalback: Callback function to call for a regular file. (Form: `` Funk (ARR) ``): The most cost-effective DC-lock: Callback function to call for a directory. (Form: `` Funk (ARR) ``): Absolute cornerable ucallback: callback function to call for an unknown file type. (Form: `` Funk (ARR) ``): Ultimate Balls Recurs: * Default: True * - It should be Recored: Returns: None    But I'm still absolutely...





















Powered by Blogger