title: Mysql Count Week Total of Current Month
body: <p>I want to COUNT my data week by week current month.</p>
  
  <p>For example;</p>
  
  <p>Today is 25th of June.</p>
  
  <p>We are on the last week of this month. So must be the 4th week of this month.</p>
  
  <ol>
  <li>Week Total = 3125</li>
  <li>Week Total = 7542</li>
  <li>Week Total = 4565</li>
  <li>Week Total = 1111 (Current week).</li>
  </ol>
  
  <p>When july starts, we will get only first week. (Let's pretend we are in the 3rd day of july)</p>
  
  <ol>
  <li>Week Total = 700</li>
  </ol>
  
  <p>Any idea?</p>
  
  <p>I did this for day of weeks but didn't get it work with the month.</p>
  
  <p>Week example:</p>
  
  <pre><code>SELECT COUNT(id) as day_total, DATE(`date`) as week_day 
  FROM edp_orders 
  WHERE DATE(`date`) &gt; DATE(CURDATE()) - INTERVAL 1 WEEK 
  GROUP BY DATE(`date`);
  </code></pre>