<?
$client = $_POST["client"];
$year = $_POST["year"];
$nonth = $_POST["month"];
$day = $_POST["day"];
$myconn =
mysql_select_db()

if (empty($client)&&empty($year)&&empty($month)&&empty($day))
{
?>
//这里是全部都没数据的界面的HTML代码;
<?
exit;
}
if (!empty($client)&&empty($year)&&empty($month)&&empty($day))
{
?>
//这里是当客户不为空,其他为空的HTML界面代码以及实现,我只留下查询的条件部分!
select * from table where client = $client;

<?
exit;
}
if (!empty($client)&&!empty($year)&&empty($month)&&empty($day))
{
?>
//这里是当客户和年份不为空,其他为空的HTML界面代码以及实现,我只留下查询的条件部分!
select * from table where client = $client and left(date,4)='$year' ;

<?
exit;
}
if (!empty($client)&&!empty($year)&&!empty($month)&&empty($day))
{
?>
//这里是当客户和年份、月份不为空,其他为空的HTML界面代码以及实现,我只留下查询的条件部分!
select * from table where client = $client and left(date,7)='$year-month' ;

<?
exit;
}
if (!empty($client)&&!empty($year)&&!empty($month)&&!empty($day))
{
?>
//这里显示全部都不为空的的HTML界面代码以及实现,我只留下查询的条件部分!
select * from table where client = $client and date='$year-month-$day' ;
<?
exit;
}
?>