date1在mysql数据类型为date，如“2007-04-01”，从access数据库中导入。使用下面的语句，没有反应
$sql = "SELECT * FROM $da WHERE TO_DAYS(`date1`) >= TO_DAYS($kaishi) and TO_DAYS(`date1`) <= TO_DAYS($jiesu) order by recordno desc";

或者
$sql="SELECT * FROM $da WHERE `date1` between $kaishi and $jiesu and $pl like $se order by recordno desc";


麻烦大家提供我一段代码，3Q