Search found 2 matches

Page 1 of 1

Search found 2 matches

Re: [MOD]- Hide Empty Category Using Query

Have modified , now it hides category with 0 quantity products. BEGIN DECLARE last_id INT; DECLARE i INT ; DECLARE q INT; SET i=1; SELECT MAX(category_id) INTO last_id FROM category; WHILE i <= last_id DO SET @q = (SELECT product.quantity FROM product_to_category INNER JOIN product ON product_to_cat...

Jump to post
  • Thu Oct 16, 2014 3:07 pm
  • Replies 2
  • Views 1591
Re: [MOD]- Hide Empty Category Using Query

Hi, would you help. When I used it for the first time it worked, now I run it and nothing happens.

Jump to post
  • Tue Oct 14, 2014 1:06 am
  • Replies 2
  • Views 1591

Page 1 of 1

Search found 2 matches