Message:

Closed. This question needs details or clarity. It is not currently accepting answers.

My Answer:
To get the suppliers name from 3 joined tables in PHP, you can use a SQL query with JOIN statements. Here is an example query:

php

$query = "SELECT suppliers.name

          FROM suppliers

          JOIN products ON suppliers.id = products.supplier_id

          JOIN orders ON products.id = orders.product_id

          WHERE orders.status = 'delivered'";

In this query, we are selecting the suppliers name from the `suppliers` table by joining it with the `products` table on the `supplier_id` column and then joining it with the `orders` table on the `product_id` column. We are also filtering the results to only include orders that have a status of 'delivered'.

You can execute this query using a database connection in PHP and fetch the results to get the suppliers name.

Rate this post

5 of 5 based on 8559 votes

John Davidson

php - how to get suppliers name from 3 joined tables