Some people may need products attributes information. Here is the MySQL code to do that. Substitute the actual customer's id for
SELECT cb.customers_basket_quantity, pd.products_name, pov.products_options_values_name
FROM customers_basket cb
JOIN products_description pd ON pd.products_id=cb.products_id
JOIN customers_basket_attributes cba ON cba.customers_id=cb.customers_id
JOIN products_options_values pov ON cba.products_options_value_id=pov.products_options _values_id
WHERE cb.customers_id =''
AND pd.language_id = '1'
More...





LinkBack URL
About LinkBacks









Bookmarks