fout in query (Opgelost)

<?php
$query			= "SELECT
								DATEDIFF(uitcheckdatum, incheckdatum) AS aantaldagen
							FROM
								bezoekers
							WHERE
								hotelID = ".mysql_real_escape_string(gethotelID($_SESSION['userID']))."
							AND
								kamerID = ".mysql_real_escape_string($row['id'])."
							AND
								uitcheckdatum < NOW()";
		$result			= mysql_query($query) or die (mysql_error());
		$row			= mysql_fetch_assoc($result);
		$dagenbezet1	= $row['aantaldagen'];
		
		$query			= "SELECT
								DATEDIFF(NOW(), incheckdatum) AS aantaldagen
							FROM
								bezoekers
							WHERE
								hotelID = ".mysql_real_escape_string(gethotelID($_SESSION['userID']))."
							AND
								kamerID = ".mysql_real_escape_string($row['id'])."
							AND
								uitcheckdatum > NOW()";
		$result			= mysql_query($query) or die (mysql_error());
		$row			= mysql_fetch_assoc($result);
		$dagenbezet2	= $row['aantaldagen'];
?>

<?php
$query			= "SELECT
								DATEDIFF(uitcheckdatum, incheckdatum) AS aantaldagen
							FROM
								bezoekers
							WHERE
								hotelID = ".mysql_real_escape_string(gethotelID($_SESSION['userID']))."
							AND
								kamerID = ".mysql_real_escape_string($row['id'])."
							AND
								uitcheckdatum < NOW()";
		$result			= mysql_query($query) or die (mysql_error());
		$row			= mysql_fetch_assoc($result);
		$dagenbezet1	= $row['aantaldagen'];
 
		$query			= "SELECT
								DATEDIFF(NOW(), incheckdatum) AS aantaldagen
							FROM
								bezoekers
							WHERE
								hotelID = ".mysql_real_escape_string(gethotelID($_SESSION['userID']))."
							AND
								kamerID = ".mysql_real_escape_string($row['id'])."
							AND
								uitcheckdatum > NOW()";
		$result			= mysql_query($query) or die (mysql_error());
		$row			= mysql_fetch_assoc($result);
		$dagenbezet2	= $row['aantaldagen'];
?>

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND uitcheckdatum > NOW()' at line 9

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND uitcheckdatum > NOW()' at line 9