if($select1=="发货时间" and $select!=""){
$query="select * from tb_shopping where fahuo_time='$select'";
$result=mysql_query($query);
$myrow=mysql_fetch_array($result);
}
$query="select * from tb_shopping where fahuo_time='$select'";
$result=mysql_query($query);
$myrow=mysql_fetch_array($result);
}
你的表中的fahuo_time是日期型的把,试试这样:select * from tb_shopping where date_format(fahuo_time,'%Y-%m-%d') = '你传入的参数'或者select * from tb_shopping where date_format(fahuo_time,'%Y-%m-%d') like '你传入的参数%'