title: Pivot Tables PHP/MySQL
body: <p>What's the best way of handling pivot tables in php/MySQL (or something to that effect)</p>
  
  <p>I have a query that returns information as below</p>
  
  <pre><code>id      eng     week        type                sourceid    userid
  
  95304   AD      2012-01-02  Technical           744180      271332
  95308   AD      2012-01-02  Non-Technical       744180      280198
  96492   AD      2012-01-23  Non-Technical       1056672     283843
  97998   AD      2012-01-09  Technical           1056672     284264
  99608   AD      2012-01-16  Technical           1056672     283842
  99680   AD      2012-01-02  Technical           1056672     284264
  100781  AD      2012-01-23  Non-Technical       744180      280671
  </code></pre>
  
  <p>And I am wanting to build a report in PHP that counts by groups with column headers of week commencing.  E.g.</p>
  
  <pre><code>week commencing: 2012-01-02    2012-01-09    2012-01-16    2012-01-23    2012-01-30
  Total:           3             1             1             1             0
  Technical:       2             1             1             0             0
  Non-Technical:   1             0             0             1             0
  </code></pre>
  
  <p>But am not really sure where to start as the headers are dynamic depending on which month the report will be run for.</p>
  
  <p>I know how to pass the details of the month and retrieve all the data in PHP, but it's currently outputting in one column rather than being able to group and put it in an array.</p>
  
  <p>Any help appreciated!</p>