mysql - 在 MySQL 中为相似数据排序并插入标题

Question

我有一个这样的表:

id  | part          | Make  
1   | Stabilizer    | Hyundai   
2   | Track Control | Hyundai  
3   | Axial Joint   | Nissan  
4   | Stabilizer    | Nissan  
5   | Stabilizer    | Peugeot

我想为属于同一工厂的每组零件订购并放置一个标题。这就像一个 ORDER BY，每组都有一个标题。我正在使用 PHP。结果如下:

        Hyundai 
1   | Stabilizer    |  
2   | Track Control |

        Nissan
3   | Axial Joint   |   
4   | Stabilizer    |

       Peugeot
5   | Stabilizer    |

Answer 1

尝试使用 SQL 语句，例如 SELECT id, part FROM tableName ORDER BY FIELD(Make, "Hyundai", "Nissan", "Peugeot");

或者只为一个 SELECT id, part FROM tableName WHERE Make="Hyundai"; 只选择一个。

编辑:

尝试一下

$result = mysqli_query($conn, SELECT id, part FROM tableName WHERE Make="Hyundai");
echo "<h1>Hyundai:</h1>";
while ($row = mysqli_fetch_array($result)){
    echo $row['id'];
    echo $row['part'];
}
$result = mysqli_query($conn, SELECT id, part FROM tableName WHERE Make="Nissan");
echo "<h1>Nissan:</h1>";
while ($row = mysqli_fetch_array($result)){
    echo $row['id'];
    echo $row['part'];
}

如果您愿意，您也可以在格式良好的 html 表格中回应这些内容。

这里$conn是一个初始化的mysqli