Mysql Query for multi Condition

Question

I was trying to make query like this:

$query= "SELECT a.virtuemart_category_id, 
   a.virtuemart_product_id, 
   b.product_name, 
   b.product_desc, 
   c.product_price, 
   d.virtuemart_media_id, 
   e.file_url 
   FROM   wgny6_virtuemart_product_categories a 
   LEFT JOIN wgny6_virtuemart_products_en_gb b 
          ON a.virtuemart_product_id = b.virtuemart_product_id 
   LEFT JOIN wgny6_virtuemart_product_prices c 
          ON b.virtuemart_product_id = c.virtuemart_product_id 
   LEFT JOIN wgny6_virtuemart_product_medias d 
          ON b.virtuemart_product_id = d.virtuemart_product_id 
   LEFT JOIN wgny6_virtuemart_medias e 
          ON d.virtuemart_media_id = e.virtuemart_media_id 
   WHERE  b.product_name IS NOT NULL";

But I want this will happen only if a.virtuemart_category_id= $id. But I can't figure out how I will add that condition.

Naveen Kumar Alone · Accepted Answer · 2013-10-07 18:59:44Z

1

Simply put extra where condition

 AND a.virtuemart_category_id = $id

at the end of your query.

i.e.

SELECT a.virtuemart_category_id,a.virtuemart_product_id,b.product_name,b.product_desc, c.product_price,d.virtuemart_media_id,e.file_url 
    FROM wgny6_virtuemart_product_categories a 
      LEFT JOIN wgny6_virtuemart_products_en_gb b ON a.virtuemart_product_id=b.virtuemart_product_id 
      LEFT JOIN  wgny6_virtuemart_product_prices c ON b.virtuemart_product_id=c.virtuemart_product_id 
      LEFT JOIN wgny6_virtuemart_product_medias d ON b.virtuemart_product_id=d.virtuemart_product_id 
      LEFT JOIN wgny6_virtuemart_medias e ON d.virtuemart_media_id=e.virtuemart_media_id 
  WHERE b.product_name IS NOT NULL AND a.virtuemart_category_id = $id

answered Oct 7, 2013 at 18:59

Naveen Kumar Alone

7,6985 gold badges40 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jibon Over a year ago

OK thanks ... I was putting like this AND a.virtuemart_category_id = '$id' may be this why it wasn't working. But so it will be without colon just $id ...thanks

Naveen Kumar Alone Over a year ago

@jibon57 pleasure to help you jibon :)

Kermit · Accepted Answer · 2013-10-07 18:59:23Z

1

SELECT ... 
FROM   ...
WHERE  b.product_name IS NOT NULL 
       AND a.virtuemart_category_id= $id // <-----------------------------------

If you're using PHP, make sure you're using binded parameters with prepared statements.

answered Oct 7, 2013 at 18:59

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Collectives™ on Stack Overflow

Mysql Query for multi Condition

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related