Komende week uitlezen uit db

<?php
$kalender = mysql_query("
SELECT * ,
 DATE_FORMAT(datum, '%d-%m-%Y') AS dedatum
WHERE 
  datum >= NOW() AND 
  datum <= NOW() + INTERVAL 7 DAY 
ORDER BY 
  titel ASC
") or die (mysql_error());
?>

<?php
$kalender = mysql_query("
SELECT * ,
 DATE_FORMAT(datum, '%d-%m-%Y') AS dedatum
WHERE 
  datum >= NOW() AND 
  datum <= NOW() + INTERVAL 7 DAY 
ORDER BY 
  titel ASC
") or die (mysql_error());
?>

<?php
 $kalender = mysql_query("
   SELECT * , 
   DATE_FORMAT(datum, '%d-%m-%Y') AS dedatum 
   FROM agendaniki
   WHERE datum <= DATE_ADD(NOW(), INTERVAL 7 DAY) 
   AND DAYOFWEEK(datum) IN (6,7) 
   ORDER BY datum ASC
  ") or die (mysql_error());
?>

<?php
 $kalender = mysql_query("
   SELECT * , 
   DATE_FORMAT(datum, '%d-%m-%Y') AS dedatum 
   FROM agendaniki
   WHERE datum <= DATE_ADD(NOW(), INTERVAL 7 DAY) 
   AND DAYOFWEEK(datum) IN (6,7) 
   ORDER BY datum ASC
  ") or die (mysql_error());
?>