title: Show records from now() till next 7 days in mysql
body: <p>I want to select rows from the datetime now till 7 days in the future, how can I do this?
  Read alot about the date function of mysql but cant figure it out, this is the MySQL code:</p>
  
  <pre><code>SELECT  id, date_format(datum, '%d/%m') AS date,
          date_format(datum, '%H:%i') AS time, date  
  FROM wedstrijden
  WHERE date &gt;= now()
  ORDER BY datum asc 
  </code></pre>
  
  <p>I have to do something with:</p>
  
  <pre><code>date &gt;= now() till 7 days further
  </code></pre>