Select data from 2 PHP tables

0

Good people, I have here two tables with the following structure:
1 - Orders, 2 - Order_items.

I need to select the data of each and display the details of the purchase, for example: Home Order # 1 (table 1)
Client: Thales (table 1)
Snacks: snack1, snack2, snack3 (table 2) (value of each snack of table 2)
Address: Customer address (table 1)
Payment: Payment (table 1)
Status: Received (table 1)

Total: total value (calculate from table 2)

How could I do this? I've made several attempts, but I'm not able to display correctly.

    
asked by anonymous 15.03.2018 / 18:42

0 answers