title: How to generate Monthly and Weekly report in Mysql?
body: <p>I want to display the data on a monthly and weekly basis, I already searched lot of stuff about this but what i found doesn't answer my question. Here is what my table looks like:</p>
  
  <pre><code>---------------
  + tblcomplain +
  ---------------
  + id          +
  + status      +
  + complain    +
  + dateposted  +
  ---------------
  </code></pre>