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
Filter records from MS access 2003 Database
Moderator: General Moderators
-
naeem ul hassan
- Forum Newbie
- Posts: 1
- Joined: Fri Jan 08, 2010 1:11 pm