title: Displaying rows for this week only in PHP
body: <p>I have two dates stored in my database as columns <code>dtp_s</code> and <code>dtp_e</code> (start, end). These derive from a populated form which the user is made to select a start and end date.</p>
  <p>I want to display records from Monday - Sunday of the current week, but my current solution is showing dates from 7 Days before - Today.</p>
  <pre><code>SELECT id
  FROM _records
  WHERE
      dtp_s &gt; unix_timestamp(now() - interval 1 week)
      AND userid = ?
  ORDER BY dtp_s DESC 
  LIMIT 5
  </code></pre>
  <p>I have tried to change <code>now()</code> to be the value of <code>strtotime( 'sunday' )</code> but this then shows no records when one does exist.</p>
  <p>Any ideas on how I only show data based on ones that start the same week (Mon - Sun) ?</p>