
Originally Posted by
Limitless
I have a SQL script that I use to query the tables for that info.
Nothing 'clean' yet, just gives me an idea of what people are putting in their 'wishlist'.
SELECT customers_firstname, customers_lastname, products_name, products_price, customers_basket_quantity
from customers_basket_later
INNER JOIN customers ON customers.customers_id = customers_basket_later.customers_id
INNER JOIN products ON products.products_id = customers_basket_later.products_id
INNER JOIN products_description ON products_description.products_id = products.products_id
I am close to completing a mailbeez module to get that info and send an email out.
Bookmarks