how would I do this...
Posted: Thu Mar 13, 2003 10:35 pm
I've got 3 tables. One table has all the inventory (each entry has an ID). Another table has all my customers (each customer has an ID). The third table has all my orders in it (each order has an order ID, a customer ID the order goes with, and the product ID of the product the order represents).
I've got it submitting orders just fine, but I want to pull this information and put it in an array (in which PHP wil then format it into an HTML table).
What I need in this array is this:
orders.ticketnum, orders.id, customers.id, customers.firstname, customers.lastname, product.size, product.style, product.pdate
How would one go about doing this? A left join? How? I group by customers.id.
-ee99ee
I've got it submitting orders just fine, but I want to pull this information and put it in an array (in which PHP wil then format it into an HTML table).
What I need in this array is this:
orders.ticketnum, orders.id, customers.id, customers.firstname, customers.lastname, product.size, product.style, product.pdate
How would one go about doing this? A left join? How? I group by customers.id.
-ee99ee