php中如何调用datepicker,如何使用datepicker,ajax,php,mysql在两个日期之...

我被赋予了使用datepicker,ajax,php和mysql在两个给定日期之间生成报告的任务.以下是我的html：

日期明智的报告

From date: To date:

User informathions will be listed here.

脚本：

$(function() {

$( "#fromdate" ).datepicker();

$( "#todate" ).datepicker();

});

function showUser(fromdate,todate)

{

if (fromdate =="" && todate=="")

{

document.getElementById("txtHint").innerHTML="";

return;

}

if (window.XMLHttpRequest)

{// code for IE7+, Firefox, Chrome, Opera, Safari

xmlhttp=new XMLHttpRequest();

}

else

{// code for IE6, IE5

xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

}

xmlhttp.onreadystatechange=function()

{

if (xmlhttp.readyState==4 && xmlhttp.status==200)

{

document.getElementById("txtHint").innerHTML=xmlhttp.responseText;

}

}

xmlhttp.open("GET","bet_date.php?fromdate="+fromdate+"&todate="+todate,true);

xmlhttp.send();

}

这是应该生成报告的php文件：

bet_date.php

include("database.php");

$fromdate=$_GET["fromdate"];

$todate=$_GET["todate"];

$sql = "SELECT * FROM bookings WHERE date between '$fromdate' and '$todate'";

$result = mysql_query($sql);

echo "

id	date	start	name	email	phone	comments	approved

while($row = mysql_fetch_array($result))

{

echo "

";

echo "

" . $row['id'] . "";

echo "

" . $row['date'] . "";

echo "

" . $row['start'] . "";

echo "

" . $row['name'] . "";

echo "

" . $row['email'] . "";

echo "

" . $row['phone'] . "";

echo "

" . $row['comments'] . "";

echo "

" . $row['approved'] . "";

echo "

";

}

echo "

";

问题是当我同时选择两个日期时什么也没发生.

在这种情况下,请帮我.

简单的例子将不胜感激.

谢谢.