รบกวนปรึกษาระบบจองห้องพักหน่อยครับ พอดีมีปัญหานิดหน่อยครับ อยากจะได้คำแนะนำดีๆจากพี่ๆที่มีประสบการณ์ครับ

SELECT *,count(rtid) as num_room FROM room_order  WHERE (chk_in BETWEEN ' 2011-11-19' and '2011-11-20') OR (chk_out BETWEEN ' 2011-11-19' and '2011-11-20')  group by rtid

SELECT *,count(rtid) as room_now FROM room_order  WHERE ('2011-11-20' BETWEEN chk_in and chk_out) OR ('2011-11-21' BETWEEN chk_in and chk_out)  group by rtid asc

$qryroom = mysql_query("SELECT *,count(rtid) as room_now FROM room_order  WHERE ('$chk_in' BETWEEN chk_in and chk_out) OR ('$chk_ou' BETWEEN chk_in and chk_out)  group by rtid asc");




<? 

	while($arr=mysql_fetch_array($qry)) { ?>                 
    <form id="frm_order" name="frm_order" method="post" action=""> 
    <table width="650" border="0" cellspacing="0" cellpadding="0">
                   
                      <tr>
                        <td><?=$arr['name']?>&nbsp;(<?=$arr['total_room']?>)</td>
                        <td width="250" rowspan="3" align="center"><img src="images/<?=$arr['image']?>" width="200" height="157"></td>
                      </tr>
                      <tr>
                        <td height="150" valign="top"><div style="margin-top:15px"><?=$arr['detail']?></div></td>
                        </tr>
                      <tr>
                        <td></td>
                        </tr>
                      <tr>
                        <td> 
		<? // while($arr2=mysql_fetch_array($qryroom)){?>                        
        ว่าง (
		<? 
		$arr2=mysql_fetch_array($qryroom); 
		if($arr2['room_now']!='0' && $arr2['room_now']!='')
		{
		 	$room_ready = $arr['total_room']-$arr2['room_now'];
			echo $arr['total_room']."<br>".$arr2['room_now'];
		}else if($arr2['room_now']==''){
			echo $arr['total_room'];
		}else{ 
			echo $arr['room_now']."ห้องเต็ม" ;
			  }
		?>
        )  ห้อง
                                <br>
        Max Adults: 1, Max Children: 0 <br>
            Rate per night: $91.00 <br>
            Rooms: 
        <? // } ?>    
    <select name="select" id="select">
<? for($i=1;$i<=10;$i++){ ?>    
      <option><?=$i?> (<? $price = $arr['total_price'] * $i; echo "฿ ".number_format($price) ?>)</option>
<? } ?>      
    </select>
    
    </td>
                        <td align="center">
                        <? if($_POST['check_room']!=''){ ?>
                        <input type="submit" name="Book" id="Book" value="Book Now"><?=$arr['rid']?>
                        <? } ?>
                        <input type="hidden" name="room_name" id="room_name" value="<?=$arr['rid']?>">
                        <input type="hidden" name="chk_in" id="chk_in" value="<?=$chk_in?>">
                        <input type="hidden" name="chk_out" id="chk_out" value="<?=$chk_out?>">
                        <input type="hidden" name="D_total" id="D_total" value="<?=DateDiff($chk_in,$chk_out);?>">
                          <a href="<?=_MYPAGE_?>?booking=true">ทดสอบ</a></td>
                      </tr>
                    </table>
                    <br>
    <div style="border-bottom-style:dotted; border-bottom-color:#CCCCCC; border-bottom-width:1px; margin-left:10px; margin-right:10px; height:20px"></div><br>
                             
        </form>
    <? } // ปิด while 
	 ?> 

if($arr2['room_now']!='0' && $arr2['room_now']!='')