title: PHP How to display mysql select query to table
body: <p>How do you display a select query to a table? I use Dreamweaver.</p>
  
  <p>Here's the query:</p>
  
  <pre><code>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);
  </code></pre>
  
  <p>The columns in the table should be</p>
  
  <pre><code> |Monthly|TotalBW|TotalChocnut|TotalHotMama|TotalMocha|TotalUbeKeso|
  </code></pre>