PHP如何显示mysql select查询到表

Question

如何显示对表的选择查询？我使用 Dreamweaver。

这是查询:

SELECT date(Date) as Monthly, sum(qtyBlackWhite) as TotalBW, sum(qtyChocnut) as TotalChocnut,
                 sum(qtyHotMama) as TotalHotMama,sum(qtyMocha) as TotalMocha,
                 sum(qtyUbeKeso) as TotalUbeKeso
FROM admin.order_queue
GROUP BY month(Date);

表格中的列应该是

 |Monthly|TotalBW|TotalChocnut|TotalHotMama|TotalMocha|TotalUbeKeso|

Answer 1

$query = "从 admin.order_queue 中选择 *";

    if($display = mysql_query($query2) or die("Error in Selecting : ".mysql_error()))
        echo("Success in Selecting <br/>"); //executing SELECT query


    while($row = mysql_fetch_array($display))
    {
        print($row['Monthly']);
        print(" | ");
        print($row['TotalBW']);
        print(" | ");
        ...

    }   // Displaying the SELECT query

尝试这样的事情