Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

phpmyadmin sql query

Recommended Posts

This is to get the product ID and quantity of the customers orders:


SELECT products_description.products_name, customers_basket.customers_basket_quantity, customers_basket_attributes.products_options_value_id

FROM customers_basket, products_description, customers_basket_attributes

WHERE customers_basket.customers_id = '12367'

AND customers_basket.products_id = products_description.products_id

AND products_description.language_id = '1'


how do i add product attribute form customers basket in here?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...