PHP and MS Access - Date/Time - PHPBuilder Forums

PHP and MS Access - Date/Time

doritos

I am having a difficulty to select Date/Time in MS Access from PHP. The error message that i always get is Data type Mismatch, as i put lines of these following codes:

$StartDate = trim($POST['StartDate']);
$EndDate = trim($POST['EndDate']);

$Time = "SELECT StartDate,EndDate FROM Schedules2 WHERE StartDate = 'StartDate' AND EndDate = 'EndDate' AND EquipmentName1='$EquipmentName1'";

$Result = odbc_exec($odbc, $Time) or die (odbc_errormsg());
$Row = odbc_fetch_array($Result);

Does anyone know how to solve the problem?

Doritos