title: How to filter last one week data on a specific day
body: <p>Hi I have a MySQL database that already has auto increment date time colomn (may information help).</p>
  
  <p>How to filter last one week data as start from specific day until next 7 day.</p>
  
  <p>example. Show data from Wednesday on this week until nest 7 day</p>
  
  <pre><code>$query="SELECT * FROM diagnosa WHERE schedule= '$a'";
  </code></pre>
  
  <p>$a is start day the data start to be shown (example Wednesday)</p>