การค้นหาข้อมูล ตามวันที่ คือผม query ไม่ออกอะครับมือไหม่จิงๆ เอาของคนอื่นมาทำต่อด้วย ใน db เก็บเป็น yyyy/mm/dd ชื่อ ฟิลล์ datein,dateout ครับ

<form name="form1" method="post" action="find.php" enctype="multipart/form-data" >
<br>
<table width="100%"  border="0" cellspacing="0" cellpadding="1" align="center">
  <tr>
                                  <td width="485" bgcolor="#EFEFEF" align="right">
                                  <span class="style15">ค้นหาจากช่วงวันที่&nbsp;
                                  <input name="todate" type="hidden" id="todate" value="<? echo date('d/m/Y'); ?>">
											<input name="datein" type=text id="datein" readonly size="12">
                                       <script language='javascript'>
													if (!document.layers) {
													 document.write("<input type=button onclick='popUpCalendar(this, form1.datein, \"dd/mm/yyyy\")' value=' Date ' style='font-size:11px'>")}
									   </script>
								</span>
                                </td>
                                  <td width="18" bgcolor="#EFEFEF" align="center"><span class="style15">ถึง</span></td>
                                  <td width="153" bgcolor="#EFEFEF" align="left">
                                          <input name="dateout" type=text id="dateout" readonly size="12"> 
                                 <script language='javascript'>
											if (!document.layers) {
											 document.write("<input type=button onclick='popUpCalendar(this, form1.dateout, \"dd/mm/yyyy\")' value=' Date ' style='font-size:11px'>")}
								 </script>
                                 </td>
                                  <td width="63" bgcolor="#EFEFEF" align="left"><input type="submit" name="search" value="search" /></td>
                                  <td width="320" align="center" class="style29"  bgcolor="#EFEFEF">&nbsp;</td>
  </tr>
</table>
</form>
<br>

<table width="1000"  border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999" bordercolordark="#FFFFFF">
  <tr bgcolor="#BBC9FF" class="unnamed1">
    <td width="37" height="25"><div align="center">ลำดับ</div></td>
    <td width="67"><div align="center">วันที่จอง</div></td>
    <td width="76" height="25"><div align="center">วันเริ่มเข้าพัก</div></td>
    <td width="124" height="25" class="unnamed1"><div align="center">วันสุดท้ายที่เข้าพัก</div></td>
    <td width="53" class="unnamed2"><div align="center">จำนวนคืน</div></td>
    <td width="75" height="25" class="unnamed2"><div align="center">เลขอ้างอิง</div></td>
    <td width="111" height="25" class="unnamed2"><div align="center">ชื่อผู้จอง</div></td>
    <td width="99" class="unnamed2"><div align="center">เบอร์โทรศัพท์</div></td>
    <td width="91" class="unnamed2"><div align="center">ยอดการชำระ</div></td>
     <td width="64" class="unnamed2"><div align="center">เงินมัดจำ</div></td>
    <td width="87" class="unnamed2"><div align="center">การชำระเงิน</div></td>
    <td width="58" height="25" class="unnamed2"><div align="center">ดู</div></td>
    <td width="30" height="25" class="unnamed2"><div align="center">ลบ</div></td>
  </tr>
  <?
	
	$sql="SELECT
rs_datajonhome.datein,
rs_datajonhome.dateout,
rs_datajonhome.countkun,
rs_datajonmain.numberjon,
rs_datajonmain.fnamejon,
rs_datajonmain.phonejon,
rs_datajonmain.phonein,
rs_datajonhome.totalbathnumberjon,
rs_datajonmain.mudjum,
rs_datajonmain.statuspay,
rs_datajonmain.datejon
FROM
rs_datajonmain
Inner Join rs_datajonhome ON rs_datajonmain.numberjon = rs_datajonhome.numberjon 
GROUP BY
rs_datajonhome.datein,
rs_datajonhome.dateout,
rs_datajonmain.numberjon,
rs_datajonmain.fnamejon,
rs_datajonmain.phonejon,
rs_datajonmain.phonein,
rs_datajonmain.statuspay,
rs_datajonhome.countkun,
rs_datajonmain.datejon
ORDER BY
rs_datajonhome.datein DESC   ";
	//echo"$sql";
$dbquery = mysql_db_query($dbname, $sql);
$num_rows = mysql_num_rows($dbquery);
$i=0;
while ($i < $num_rows)
{
$result = mysql_fetch_array($dbquery);
$datein = $result[0];
$dateout = $result[1];
$countkun = $result[2];
$numberjon = $result[3];
$namejon = $result[4];
$phonejon = $result[5];
$phonein = $result[6];
$totalbathnumberjon = $result[7];
$mudjum = $result[8];
$statuspay = $result[9];
$datejon = $result[10];

		list($year, $month, $day) = split('[/.-]', $datein);
		//$year = $year - 543;
		$datein=  "$day/$month/$year";
		list($year, $month, $day) = split('[/.-]', $dateout);
		//$year = $year - 543;
		$dateout=  "$day/$month/$year";
		list($year, $month, $day) = split('[/.-]', $datejon);
		//$year = $year - 543;
		$datejon=  "$day/$month/$year";
		$order  = $i+1;	
?>
  <tr class="unnamed1" style="cursor:pointer" onMouseOver="this.style.backgroundColor=&quot;#99CCFF&quot;" onmouseout='this.style.backgroundColor=&quot;#FFFFFF&quot;'border="0">
    <td><div align="center"><span class="unnamed2"><? echo"$order"; ?>
    </span></div></td>
    <td><div align="center"><? echo"$datejon"; ?></div></td>
    <td><div align="center"><? echo"$datein"; ?></div></td>
    <td class="unnamed2"><div align="center">&nbsp;<? echo"$dateout"; ?></div></td>
    <td><div align="center"><? echo"$countkun"; ?></div></td>
    <td><div align="center"><? echo"$numberjon"; ?></div></td>
    <td><div align="center"><? echo "$namejon";  ?></div></td>
    <td><div align="center"><? echo"$phonejon"; ?></div></td>
    <td><div align="Center"><? echo number_format($totalbathnumberjon ,0 , '.' , ',');  ?></div></td>
    <td><div align="center"><? echo"$mudjum"; ?></div></td>
    <td><div align="center"><? if($statuspay == '0'){ echo"<font color=\"Red\">ค้างชำระ </font><br>" ;  } if($statuspay == '1'){ echo"<font color=\"#0099FF\">ชำระแล้ว </font><br>"; } ?></div></td>
    <td><div align="center"><? echo"<A HREF='viewjon.php?numberjon=$numberjon'>
  ดูการจอง</a>"; ?></div></td>
    <td><div align="center" ><a href='find.php?del=<?=$numberjon?>' onclick="return confirm('ท่านต้องการลบ ?');" >
ลบ</a></div></td>
  </tr>
  <?
  $i++;
}
?>

</table>