$sql = "SELECT r.room_id,r.roomtype_id,r.status as status,d.check_in as check_in, d.check_out as check_out FROM room r,roomdetail d where r.room_id=d.room_id and r.roomtype_id = '$roomtype_id' and NOT(d.check_in <='$check_out' AND d.check_out >='$check_in')order by r.room_id asc"; $sql="select * from room where status='1' and roomtype_id='$roomtype_id'";