สอบถามเรื่องระบบจองห้องพัก งมมาหลายวันแล้วครับ รบกวนขอคำแนะนำด้วยครับ

<?

	date_default_timezone_set('UTC');		

/*	$startdate = $_GET['txtChekIn']; // '2011-08-01';
	$enddate = $_GET['txtCheckOut']; // '2011-08-31';*/
	$startdate ='2011-11-25'; // '2011-08-01';
	$enddate ='2011-11-26'; // '2011-08-01';
	while (strtotime($startdate) <= strtotime($enddate))
	{
		echo $startdate."<br>";
		
		$strSQL = "SELECT * FROM room WHERE 1";
		$objQuery = mysql_query($strSQL) or die (mysql_error());
		$a=0;
		while($objResult = mysql_fetch_array($objQuery))
		{
				$strSQL2 = "SELECT * FROM rent WHERE ( '$startdate' BETWEEN check_in and check_out) AND rid = '".$$objResult["rid"]."' ";
				$objQuery2 = mysql_query($strSQL2) or die (mysql_error());
				$objResult2 = mysql_fetch_array($objQuery2);

				if(!$objResult2)
				{
				 echo "ห้อง ".$objResult2['rid']." ว่าง<br>";
				}
		}

		echo "<hr>";
		$startdate = date ("Y-m-d", strtotime("+1 day", strtotime($startdate)));
		
	}

?>

while (strtotime($startdate) <= strtotime($enddate))  

$strSQL = "SELECT * FROM room WHERE 1";

while($objResult = mysql_fetch_array($objQuery))

$strSQL2 = "SELECT * FROM rent WHERE ( '$startdate' BETWEEN check_in and check_out) AND rid = '".$$objResult["rid"]."' ";  ใช้เช็คห้องว่าง

<?

	date_default_timezone_set('UTC');		

/*	$startdate = $_GET['txtChekIn']; // '2011-08-01';
	$enddate = $_GET['txtCheckOut']; // '2011-08-31';*/
	$startdate ='2011-11-25'; // '2011-08-01';
	$enddate ='2011-11-26'; // '2011-08-01';
	while (strtotime($startdate) <= strtotime($enddate))
	{
		echo $startdate."<br>";
		
		$strSQL = "SELECT * FROM room WHERE 1";
		$objQuery = mysql_query($strSQL) or die (mysql_error());

		while($objResult = mysql_fetch_array($objQuery))
		{
				$strSQL2 = "SELECT * FROM rent WHERE ( '$startdate' BETWEEN check_in and check_out) AND rid = '".$$objResult["rid"]."' ";
				$objQuery2 = mysql_query($strSQL2) or die (mysql_error());
				$objResult2 = mysql_fetch_array($objQuery2);

				if(!$objResult2)
				{
				 echo "ห้อง ".$objResult['rid']." ว่าง<br>";
				}
		}

		echo "<hr>";
		$startdate = date ("Y-m-d", strtotime("+1 day", strtotime($startdate)));
		
	}

?>

'".$$objResult["rid"]."'  ต้องเป็น '$objResult[rid]'

		while($objResult = mysql_fetch_array($objQuery))
		{
				$strSQL2 = "SELECT *,count(rid) as avaliable FROM rent WHERE ('$startdate' BETWEEN check_in and check_out) AND rid = '$objResult[rid]' group by rid";
				$objQuery2 = mysql_query($strSQL2) or die (mysql_error());
				$objResult2 = mysql_fetch_array($objQuery2);


				if(!$objResult2)
				{
				 echo "ห้อง ".$objResult['rid']." ว่าง<br>";
				}else{
				 echo "ห้อง ".$objResult['rid']." ไม่ว่าง<br>";
				}
		}

<?

	date_default_timezone_set('UTC');		

/*	$startdate = $_GET['txtChekIn']; // '2011-08-01';
	$enddate = $_GET['txtCheckOut']; // '2011-08-31';*/
	$startdate ='2011-11-24'; // '2011-08-01';
	$enddate ='2011-11-30'; // '2011-08-01';
	while (strtotime($startdate) <= strtotime($enddate))
	{
		echo $startdate."<br>";
		
		$strSQL = "SELECT * FROM room WHERE 1";
		$objQuery = mysql_query($strSQL) or die (mysql_error());

		while($objResult = mysql_fetch_array($objQuery))
		{
				$strSQL2 = "SELECT *FROM rent WHERE ('$startdate' BETWEEN check_in and check_out) AND rid = '$objResult[rid]' ";
				$objQuery2 = mysql_query($strSQL2) or die (mysql_error());
				$row = mysql_num_rows($objQuery2);
				$objResult2 = mysql_fetch_array($objQuery2);

				if(!$objResult2)
				{
				 //echo "ประเภท ".$objResult['tid']." ห้อง ".$objResult['rid']." ว่าง<br>";
				}else{
				 echo "ประเภท ".$objResult['tid']." ห้อง ".$objResult['rid']." ไม่ว่าง<br>";
				}
		}

		echo "<hr>";
		$startdate = date ("Y-m-d", strtotime("+1 day", strtotime($startdate)));
		
	}

?>

while($objResult = mysql_fetch_array($objQuery))
{
		$strSQL2 = "SELECT count(rid) as avaliable FROM rent WHERE ('$startdate' BETWEEN check_in and check_out) AND rid = '$objResult[rid]' group by rid";
		$objQuery2 = mysql_query($strSQL2) or die (mysql_error());
		$objResult2 = mysql_fetch_array($objQuery2);
		if(!$objResult2)
                   {
		                 echo "$objResult['avaliable']" ว่าง<br>";
		   } else { 
		                 echo "$objResult['avaliable']" ไม่ว่าง<br>";
		  }
}