不了解连接功能

Thanks in advance for any time you spend on my question.

I am trying to display data in a way that will display the manufacturer as a name instead of a number.

Basically when they store the data they choose a manufacturer from a drop down which is generated from a table.. IE Trogues = 1 so products stores the #1 so I know that any beer is associated with trogues is 1. Now I want to display the data but instead of having a 1 I would like to have Trogues be displayed. Where you see manufacturer in the echo code below..

I am not understanding the process logic here..

error_reporting(E_ALL);
ini_set('display_errors', 1);

$sql = "SELECT * FROM products 
LEFT JOIN manufacturer 
ON product.manufacturer = manufacturer.id  
ORDER BY manufacturer.id, product.id";


$query = mysql_query($sql);

while($row = mysql_fetch_array($query)) {
echo "

<div class=reportclientproduct>".$row['manufacturer']."  -  <a href=".$row['website']." target=_blank>".$row['product']."</a></div>";
}

Have you tried the query like this:

$sql = "SELECT man.id AS manufac, products.product AS prod FROM products 
    LEFT JOIN manufacturer as man
    ON product.manufacturer = manufacturer.id  
    ORDER BY manufacturer.id, product.id";

$query = mysql_query($sql);

while($row = mysql_fetch_array($query)) { 
    echo "
    ".$row['manufac']." - ".$row['prod']."

    ";
}

Assuming that the table products had a column named manufacturer which holds the ID of the manufacturer, and that both tables have columns name ID which hold the ID of the table item.

Also the JOIN functions may vary based on the database you use. But the aforementioned method is for mysql.