如何使用PHP更新当前日期的mysql？

Question

I am trying to update a MySQL table with current date into a column which type is DATE. current date structure is (2014-05-15). I've tried a few ways but it is not updating the date, however it is updating other fields.

MySQL query.

$q = "UPDATE TABLE SET
    DESCRIPTION     =".$db->qstr($string).",
        DATE        =".$db->qstr(date('Y-m-d')).",
    LAST_ACT        =".$db->qstr( time())."
    WHERE  ID=".$db->qstr( $id); 

I've tried DATE = DATE(NOW()), and DATE = DATE(), but it is not updating in MySQL,

Any suggestions?

Answer 1

Instead of DATE = DATE(NOW()). Try DATE = NOW()