Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Getting a list of orders direct from the DB


butchevans

Recommended Posts

Posted

Perhaps I am just missing this in the descriptions, but I cannot find a mod that will allow me to create a list of customers who have purchased a specific product. I'm just not sure how to do the join in mysql to query for the customer info in the orders table and the product info from orders_products (I think that was the table). I suppose I'm wanting to join the orders_id from each. Any help? I can do the php to build the page/result I need, but I need help with the query.

Archived

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

×
×
  • Create New...