title: Showing data from a mysql table grouped by the month
body: <p>Basically I have a lot of data in a table and its creation date with it. I want to show all of the data from the table, however in its output it need to be in date order, and then with a heading of the month it was created in above it. </p>
  
  <p>i.e. </p>
  
  <p><strong>January</strong>
  data1
  data2
  data3</p>
  
  <p><strong>February</strong>
  data4
  data5</p>
  
  <p><strong>March</strong>
  data6
  data7
  data8
  data9</p>
  
  <p>Is this possible from one query? I'm using php and mysql.</p>
  
  <p>Thanks</p>
  
  <p>Table Layout will be something like:</p>
  
  <pre><code>ID | Type | Content | User | Colour | Creation Date
  </code></pre>
  
  <p>It's all theory at the moment, but I will be creating it later today and tomorrow. I just needed to know if it's possible.</p>