Filter records from MS access 2003 Database
Posted: Fri Jan 08, 2010 1:29 pm
I am a new one in PHP ,I am using php 5.2 with MS access 2003 Database.
i want to filter records from a table on the base of date.The date format in Database table is "25/05/2009".
My SQl Query is:
$Sdate="05/25/2009"; //date format is m/d/Y
"SELECT * from tbl where Start_Date=". $Sdate ;
When i runs application it returns no records but when i run same query in MS access Query analyser,it returns data.
i think there is some date format problem.please guide me.
Thanks
i want to filter records from a table on the base of date.The date format in Database table is "25/05/2009".
My SQl Query is:
$Sdate="05/25/2009"; //date format is m/d/Y
"SELECT * from tbl where Start_Date=". $Sdate ;
When i runs application it returns no records but when i run same query in MS access Query analyser,it returns data.
i think there is some date format problem.please guide me.
Thanks