在 php/html 的多列中显示单列 mysql 数据

Question

我想在HTML页面中显示MySQL数据，如下所示。

I want something like this:                
+-------------+-------+-------------+------------+--------------+-----------+
| Train Type  |TraNo  | Dep. Station| Dep. Time  | Arr. Station | Arr. Time |
+-------------+-------+-------------+------------+--------------+-----------+
| Fast        | 81    |Taipei       | 7:48       | Taitung      | 13:04     |
+-------------+-------+-------------+------------+--------------+-----------+
But I have this:
+-------------+-------+-------------+------------+--------------+-----------+
| Train Type  |TraNo  | Dep. Station| Dep. Time  | Arr. Station | Arr. Time |
+-------------+-------+-------------+------------+--------------+-----------+
| Fast        | 81    |Taitung      | 13:04      | Taitung      | 13:04     |
+-------------+-------+-------------+------------+--------------+-----------+

我已经确认SQL查询是正确的。 这是参考

$sql = "SELECT ttype.TyName, train.TraNo, a.StaName, c.Time,b.StaName , d.Time
FROM (((((ttype RIGHT JOIN train
ON ttype.TyNo=train.TyNo)
RIGHT JOIN pass c
ON train.TraNo=c.TraNo)
RIGHT JOIN station a
ON a.StaNo=c.StaNo)
RIGHT JOIN pass d
ON train.TraNo=d.TraNo)
RIGHT JOIN station b
ON b.StaNo=d.StaNo)      
WHERE c.Time < d.Time
AND a.StaName='Taipei' 
AND b.StaName='Taitung' ";
$result = mysqli_query($link, $sql) or die("can't reach" . mysqli_error( ));
$data = array(); // create a variable to hold the information
while ($row = mysqli_fetch_array($result)){
$data[] = $row; // add the row in to the results (data) array
?>
<?php print_r($data); ?>
<!--<tr>
<td><?php echo $data ?></td> 
<td><?php echo $row['TyName']?></td>
<td><?php echo $row['TraNo']?></td>
<td><?php echo $row['StaName']?></td>
<td><?php echo $row['Time']?></td>
<td><?php echo $row['StaName']?></td>
<td><?php echo $row['Time']?></td>
</tr>
-->
<?php
}
?>

我尝试过 PHP 数组，但打印的信息显示 PHP 将出发站与到达站数据重叠。 数组显示重叠 另外，我尝试了HTML表格方法，但结果也是重叠的。

Answer 1

你可以在sql stmt上给出别名。

SELECT ttype.TyName, train.TraNo, a.StaName as dstation, c.Time as dtime,b.StaName as astation , d.Time as atime

检索时，使用

<?php echo $row['dstation']?>
<?php echo $row['dTime']?>
<?php echo $row['astation']?>
<?php echo $row['aTime']?>