‚Äč
 
Your Shopping Cart  
 
SELECT a.*, b.`building_materials_id`, b.`product_name`, b.`product_price`, b.`product_image`, b.`category_id`, c.`building_materials_category_id`, c.`building_materials_category_name` FROM `tbl_cart` AS a LEFT JOIN `tbl_building_materials` AS b ON b.`building_materials_id`=a.`building_materials_id` LEFT JOIN `tbl_building_materials_category` AS c ON c.`building_materials_category_id`=b.`category_id` WHERE a.`session_id`='cnnhu09hg1ij6ni2d16mnp3hd3' ORDER BY a.`cart_id` DESC
Unknown column 'a.building_materials_id' in 'on clause'
PRODUCT QUANTITY PRICE