Tussen 2 datums selecteren (Opgelost)

$begindatum = $_POST['begindag']."-".$_POST['beginmaand']."-".$_POST['beginjaar'];
$einddatum = $_POST['einddag']."-".$_POST['eindmaand']."-".$_POST['eindjaar'];

$result = mysql_query("SELECT * FROM zoekopdrachten WHERE DATE_FORMAT(datum, '%d-%m-%Y') BETWEEN DATE_FORMAT(".$begindatum.",'%d-%m-%Y') AND DATE_FORMAT(".$einddatum.",'%d-%m-%Y') ORDER BY datum")or die(mysql_error());

$begindatum = $_POST['begindag']."-".$_POST['beginmaand']."-".$_POST['beginjaar'];
$einddatum = $_POST['einddag']."-".$_POST['eindmaand']."-".$_POST['eindjaar'];
 
$result = mysql_query("SELECT * FROM zoekopdrachten WHERE DATE_FORMAT(datum, '%d-%m-%Y') BETWEEN DATE_FORMAT(".$begindatum.",'%d-%m-%Y') AND DATE_FORMAT(".$einddatum.",'%d-%m-%Y') ORDER BY datum")or die(mysql_error());

SELECT * 
FROM zoekopdrachten 
WHERE DATE_FORMAT(datum, '%d-%m-%Y') 
BETWEEN '".$begindatum."' AND '".$einddatum."' 
ORDER BY datum

SELECT * 
FROM zoekopdrachten 
WHERE DATE_FORMAT(datum, '%d-%m-%Y') 
BETWEEN '".$begindatum."' AND '".$einddatum."' 
ORDER BY datum