shopping_cart
Cart
menu_open
Menu
Blog

Menu

shopping_cart Cart
close Close
Please Log in to see your Cart Items
$mc_r_s = "main_cat='$mc_r' "; if($c1!='') { $c1_r_s = " and sub_cat_1 = '$c1_r' "; } else { $c1_r_s = " "; } if($c2!='') { $c2_r_s = " and sub_cat_2 = '$c2_r' "; } else { $c2_r_s = ""; } if($c3!='') { $c3_r_s = " and sub_cat_3 = '$c3_r' "; } else { $c3_r_s = ""; } if($c4!='') { $c4_r_s = "and sub_cat_4 = '$c4_r' "; } else { $c4_r_s = ""; } if($u_r!='') { $u_r_s = "and use_type = '$u_r' "; } else { $u_r_s = ""; } $query_product=" SELECT * FROM product_basic RIGHT JOIN product_extra_info ON product_basic.id = product_extra_info.product_id RIGHT JOIN product_price_info ON product_basic.id = product_price_info.product_id RIGHT JOIN product_color_size ON product_basic.id = product_color_size.product_id RIGHT JOIN product_description ON product_basic.id = product_description.product_id where p_type='IT' and $mc_r_s"." $c1_r_s"." $c2_r_s"." $c3_r_s"." $c4_r_s"." $u_r_s ORDER BY id DESC"; ?>

Accessories