ช่วยดูโค้ด ค้นหาวันที่ให้หน่อยครับผม มันไม่ออกตามเงื่อนไขเลยนะครับผม

<?php
$i=1;
while($p=mysql_fetch_array($data))
	{	$rid=$p['roomid'];
	$roomnum=$p['roomnum'];
	$type=$p['roomtype'];
	$detail=$p['roomdetail'];
	$status=$p['status'];
	$price=$p['price'];
	$pname='pic_room/'.$p['pic'];
	$detail = nl2br($detail);
	echo "<tr>";
	echo "<td align=center>$i</td>";
	echo "<td align=center><img src='$pname' height='150' wight='150'></td>";
					echo "<td align=left>หมายเลขห้อง : $roomnum<br>";
					echo "ราคา : ".number_format($price,2)."<br>";
					if ($type==1)
					{echo "ประเภทห้อง : เตียงเดี่ยว <br>";}
					else
					{echo "ประเภทห้อง : เตียงคู่ <br>";}
					echo "รายละเอียด : $detail";
			if ($issearch==0){
					if ($status=="1"){
						echo "<td align=center>ห้องว่าง</td>" ;
					} else {
						if ($status == 2){
						echo "<td align=center>มีผู้จอง<br/>" ;}
						else {
						echo "<td align=center>มีผู้พัก<br/>" ;}
	$sql = "select max(room_date) from tblroomschedule where roomid = $rid";
	$result = mysql_query($sql);
	$row = mysql_fetch_array($result);
	$datefree1 = $row[0];
	$datefree2 = date("Y-m-d",strtotime($datefree1 . " +1 day"));
						echo "จะว่าง " . showdaterevthai($datefree2);
	echo "</td>";
}
			} // end issearch==0				
			if ($issearch==1){
			echo "<td align=center>วันที่ว่าง<br/>" ;
	$dateloop=$fixdateloop;
	if ($dateloop==$dateend){
		$rows_per_page = 2;
		if($room==1)
		{$sql = "select * from tblroomschedule where roomid in (select roomid from tblroom where roomnum = $roomsearch)";
		 $sql = $sql." and room_date = '$dateloop'"; $result = mysql_query($sql);}
		else
		{$sql="select * from tblroomschedule where roomid = $rid and room_date = '$dateloop'"; $result = mysql_query($sql);} //คิวรี่ คำสั่ง
		if (mysql_num_rows($result)==0){
		echo showdaterevthai($dateloop) . "<br/>";}			
			} else {
				while ($dateloop < $dateend){
				if($room==1)
				{$sql = "select * from tblroomschedule where roomid = $rid in (select roomid from tblroom where roomnum = $roomsearch)";
				 $sql =$sql." and room_date = '$dateloop'";}
				else
				{$sql="select * from tblroomschedule where roomid = $rid and room_date = '$dateloop'";} //คิวรี่ คำสั่ง
					$result = mysql_query($sql);
					if (mysql_num_rows($result)==0){
							echo showdaterevthai($dateloop) . "<br/>"; 
					}
					
					$dateloop = date("Y-m-d",strtotime($dateloop . " +1 day"));
				}
			}				
					echo "</td>";
			} 
					echo "</tr>";
					$i++;
				}
//echo $sql; ?>

<?php
ob_start();
session_start();
require_once("connect.php");
include("inc/paging.inc.php");
require_once("functions.php");
/*$login=$_SESSION['login'];
if($login<>"OK")//ป้องกันการเข้าเมนูโดนไม่่ผ่านหน้าlogin
{ 
	?> <script language="javascript"> window.alert("คุณไม่สามารถใช่ส่วนนี้ได้ กรุณาล๊อกอินก่อน"); </script> <?php
	header("location:login.php");
}*/

if (isset($_GET['btnsearch']))
		{$txtsearch = $_GET['txtsearchroom1'];
		 $sql = "select * from tblroom where roomnum LIKE '$txtsearch%'"; $data=mysql_query($sql);
		} else
{$sql="select * from tblroom"; $data=mysql_query($sql);}
$dateloop=date("Y-m-d");
$fixdateloop = $dateloop;
//echo $sql;
$issearch=0;
$room=0;
$roomsearch=0;
if (isset($_GET['btndate'])){
$begindate = $_GET['begindate'];
$enddate = $_GET['enddate'];
$roomsearch = $_GET['txtsearchroom2'];
	if($roomsearch =='')
	{$room=0;}
	else
	{$room=1;}
		if ($begindate == ''||$enddate =='')
		{?> <script language="javascript"> window.alert("คุณยังไม่ได้เลือกวัน"); </script> <?php }
			else{
			$people="0";
			$issearch=1;
		//$sql="select * From tblroom where room_datein > '$begindate' or room_dateout < '$begindate'";
		//$sql=$sql." and room_datein > '$enddate' or room_dateout < '$enddate' or status = 'ห้องว่าง'";
		
				$dateloop = showdate($begindate);
				if ($enddate==""){ $enddate = $begindate ; }
				$dateend = showdate($enddate);
				$sdateend = showdaterev($enddate);
				if  ($dateloop>$dateend){ $dateend = $dateloop; $dateloop =  showdate($enddate); }
			
				$datebegin = date("Y-m-d",strtotime("now +7 day"));
				

		}
		$fixdateloop = $dateloop;
}echo $room."หมายเลขห้อง".$roomsearch;
?>