php - 如何在 HTML 水平表中显示 mysql 查询输出

Question

这是我的查询....

$sql20 = "SELECT size, SUM(sizeorderqty) as oqty FROM `colsize_tbl` WHERE Style_no='4320'";  

这些是为在 html 表中显示输出而编写的 PHP 代码

<?php
echo "<table border='1' cellpadding='3' cellspacing='0'> ";
while ($row20=mysql_fetch_array($result20)){
echo "<tr>";
echo "<td> Size </td>";
echo "<td>" . $row20['size']."</td>";
echo "</tr>";
echo "<tr>";
echo "<td> Order Qty </td>";
echo "<td>" . $row20['oqty']."</td>";
}
echo "</tr>";
echo "</table>";
?>

但我的输出是

Size      | L   |
Order Qty | 300 |
Size      |M    |
Order Qty |250  |
Size      |S    |
Order Qty |500  |

请建议我按以下格式显示上表

Size       | S   | M   | L   |
Order Qty  | 500 | 250 | 300 |

Answer 1

您的 HTML 标记似乎有点无效。

由于没有你的数据库我无法在本地运行代码，你能告诉我这是否可行吗？

这是您的查询:

$sql20 = "SELECT size, SUM(sizeorderqty) as oqty FROM `colsize_tbl` WHERE Style_no='4320'";

这是在 HTML 表格中显示输出的 PHP 代码:

<?php
    echo "<table border='1' cellpadding='3' cellspacing='0'>";
    $sizes = array();
    $oqtys = array();
    while ($row20 = mysql_fetch_array($result20)) {
        $sizes[] = $row20['size'];
        $oqtys[] = $row20['oqty'];
    }
    echo "<tr>";
    echo "<td>Size</td>";
    foreach($sizes as $size) {
        echo "<td>" . $size . "</td>";
    }
    echo "</tr><tr>";
    echo "<td>Order Qty</td>";
    foreach($oqtys as $oqty) {
        echo "<td>" . $oqty . "</td>";
    }
    echo "</tr></table>";
?>