php - PHP 从 MS Access MDB 收集数据时出现意外结果

Question

我有以下编码，但 WHERE 子句中的条件不起作用......

<?php 
$con = odbc_connect("attend", "", "123");
 if ($con) {
        $sql = "
            select 
                accessrec.eid,
                employee.fullname,
                Format(CDate(Left(accessrec.accessdate,4) & '/' & Mid(accessrec.accessdate,5,2) & '/' & Right(accessrec.accessdate,2)),'dd/mm/yyyy') as accessdate, 
                iif(len(trim(AccessRec.accesstime))>5,left(AccessRec.accesstime,2) & ':' & mid(AccessRec.accesstime,3,2) & ':' & right(AccessRec.accesstime,2),left(AccessRec.accesstime,1) & ':' & mid(AccessRec.accesstime,2,2) & ':' & right(AccessRec.accesstime,2)) as accesstime 
            from accessRec 
            left join employee on accessrec.eid = employee.eid 
            WHERE (accessdate >=#01/01/2018# AND employee.fullname='Leung Ka Hei-MIS') 
            ORDER BY accessdate ASC, accesstime ASC
        ";
    $result = odbc_exec($con, $sql);
}
?>

过滤不适用于 WHERE 子句，因此它将显示所有记录...

标签： php