I am connecting to an Access database with PHP using and ODBC driver.
I am trying to pull data out between 2 dates. The following query works fine in sql view in access.
When I run it in PHP and echo out the count it says there is only 1 result and it displays the first record, but there should be over 150 records returned.
If I leave out the time stuff it works fine in php and access.
BETWEEN #2003-10-16 10:14:22 PM# AND #2003-10-16 10:14:25 PM#;