title: php Generate monthly sales report from user input
body: <p><img src="https://i.stack.imgur.com/grjl8.jpg" alt="asd"></p>
  
  <p>I'm so lost on this, I would like to generate  the sales from the selected month and year when user clicks <code>generate reports</code>. What could be the possible query for this ?? say for example the sales from <code>November 2013</code> to <code>January 2014</code> and the output would be like</p>
  
  <pre><code>MONTH     Sales   Year
  November  100     2013
  December  200     2013
  January   100     2014
  </code></pre>
  
  <p>These are sample data from my DB that might be useful or what could be the possible changes that I should do on my DB to accomplish this ??</p>
  
  <pre><code>ORDER_ID  ORDER_DATE(timestamp)  MONTH(varchar)  YEAR(varchar)
    2       2013-11-28 02:01:40     November         2013
    4       2013-12-26 03:01:40     December         2013
    5       2014-01-28 01:01:40     January          2014
  </code></pre>
  
  <p>Need your help badly :'(</p>