php - 使用 MySQL 关系表循环行

Question

我有三个表:

门

ID |名称 |价格|等等

面板

ID |名称

门关系

door_id | panel_id

我想生成一个 HTML/PHP 表格，每扇门一行一行，显示与其相关的面板:

门列表

名称 |价格|面板|等等

我在为此编写 MySQL 查询时遇到问题。我应该如何从数据库请求这些信息？谢谢!

我尝试过的:

<?php   
$catalog_query = mysqli_query($con,"SELECT * FROM door");


$panel_query = mysqli_query($con,"SELECT door.name as door, panel_profile.name as panel FROM door_relationship
INNER JOIN door
    ON door_relationship.doorid = door.door_id
INNER JOIN panel_profile 
    ON door_relationship.panel_id = panel_profile.panel_id
INNER JOIN door");


while($row = mysqli_fetch_array($catalog_query) and $row2 = mysqli_fetch_array($panel_query))
{
echo    '<tr>
            <td>' . $row['door'] . '</td>
            <td>' . $row['description'] . '</td>
            <td>' . $row['sqft_price'] . '</td>
            <td>' . $row['door_price'] . '</td>
            <td>' . $row2['panel'] . '</td>
            <td>' . $row['joint'] . '</td>
            <td>' . $row['collection'] . '</td>
            <td>' . $row['min_sqft'] . '</td>
            <td>' . $row['min_width'] . '</td>
            <td>' . $row['min_height'] . '</td>
            <td>' . $row['max_width'] . '</td>
            <td>' . $row['max_height'] . '</td>
        </tr>'
        ;
}
?>  

Answer 1

查询必须是:

select d.name doorName, p.name panelName, otherFields from Door d, Panel p, Door-Relationship r where p.id = r.panel_id and d.id = r.door_id group by d.id order by d.id asc