Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

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

Archived

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

×
×
  • Create New...