php - 在 3 列中显示字母查询

Question

我正在尝试以水平（3 列）的形式显示查询结果，现在它以垂直向下的形式显示结果。

这是当前的结果：

这是代码：

$query = 'SELECT DISTINCT UCASE(LEFT(Name, 1)) AS letter FROM parts ORDER BY Name';
$myconn = $con->query($query);

if ($myconn) {
while ($row = $myconn->fetch_object()) {
$letter = htmlentities($row->letter);
echo "<a href='#$letter'>$letter</a> | ";
}}
$query = 'SELECT Name FROM parts ORDER BY Name';
$myconn = $con->query($query);
if ($myconn) {
$row = $myconn->fetch_object();
while ($row) {
$c = $row->Name[0];
$letter = htmlentities(strtoupper($c));
echo '<div class="row justify-content-lg-center">';
echo "<h4 id='$letter'>$letter</h4>";
do {
 echo "<a href='#$letter'>";
 echo  htmlentities($row->Name), '<br /></a>';
 echo '</div>';
 }while ($row = $myconn->fetch_object() and $row->Name[0] == $c);
 }
 }

这是我试图达到的结果：

标签： php