title: How to get a count even if there are no results corresponding mysql?
body: <p>I am formalating a query to give the number of reports submitted over the last year ordered by date.
  I get the current year and month with php: </p>
  
  <pre><code>$year = date('Y') - 1;
  $month = date('m');
  </code></pre>
  
  <p>and execute the following query:
  SQL:</p>
  
  <pre><code>SELECT month(date_lm) AS `month` ,
  count(*) AS `count`
  FROM `reports` 
  WHERE (status = 'submitted') 
  AND (date_lm &gt; 2012-08) 
  GROUP BY month(date_lm) 
  ORDER BY month(date_lm) ASC
  </code></pre>
  
  <p>And because there has only been 1 submitted in the last year it gives me only 1 result...</p>
  
  <pre><code>| month  |  count  |
  |   7    |    1    |
  </code></pre>
  
  <p>But I would like the result set to show:</p>
  
  <pre><code>| month  |  count  |
  |   9    |    0    |
  |   10   |    0    |
  |   11   |    0    |
  |   12   |    0    |
  |   1    |    0    |
  |   2    |    0    |
  |   3    |    0    |
  |   4    |    0    |
  |   5    |    0    |
  |   6    |    0    |
  |   7    |    1    |
  |   8    |    0    |
  </code></pre>
  
  <p>Is that possible?</p>