UPDATE projects SET dex=‘{FD35CF46-D1F4-A05F-D4C6-16CF86A2E05F}’, Name=‘h’, Designation=‘f’, Phone=59, PMC=1, Quality=1, Progress=1, Issues=1, Responsiveness =1, Commitments=1, Safety=1, SLevel=1, Total=8, Improvement=‘No comment for now’, Future=‘N’, Date=2012/06/21 WHERE dex=‘{135C2B55-B95D-786D-9CBD-9563B3AF04B3}’
The date shown here is the current date. However, the date stored in my database is 0000-00-00. what could be wrong? I am sanitizing the date as date type.
sanitize($date, "date");
I am using the $date=date(Y/m/d) to get today’s date. Do let me know if you can help. Thanks.
Have you tried CURRENT_TIMESTAMP in the query to store the date? I think CURRENT_TIMESTAMP will work across multiple databases systems but can’t be sure, I don’t have a copy of @r937;'s book to hand to check