title: Reports by month with php and mysql?
body: <p>I want to know how to display report by month using PHP and Mysql</p>
  
  <p>Example of Report on the web page:</p>
  
  <pre><code>January 2011
  ==============
  Store  Name    |  Total Order Cost
  SHOP A         |  £123 
  SHOP B         |  £100
  
  February 2011
  ==============
  Store  Name    |  Total Order Cost
  SHOP A         |  £123 
  SHOP B         |  £100
  SHOP C         |  £99.40
  </code></pre>
  
  <p>I have mysql tables</p>
  
  <p><strong>tbl_shop</strong></p>
  
  <ul>
  <li><p>ShopID</p></li>
  <li><p>ShopName</p></li>
  </ul>
  
  <p><strong>tbl_order</strong></p>
  
  <ul>
  <li><p>OrderID</p></li>
  <li><p>ShopID</p></li>
  <li><p>OrderDate</p></li>
  <li><p>Total</p></li>
  </ul>