title: DateTime between dates pdo
body: <p>How can I get weekly data in mysql ? 
  This code does not work for me. </p>
  
  <pre><code> public function getWeeklyWinners() {
              $today = time();
              $a_week_ago = strtotime("-1 week");
              $sql = "SELECT * FROM money_transfer WHERE send_date BETWEEN ? AND ?";
              $query = $this-&gt;db-&gt;prepare($sql);
              $query-&gt;execute(array($today, $a_week_ago));
              if ($query-&gt;rowCount())
                  return $query-&gt;fetchAll();
              return false;
          }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/s6vA2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s6vA2.png" alt="enter image description here"></a></p>