TimeStamp Column Problem...

[WeirdMystery]

I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here.  I coded my self a forum, when you reply to a topic, the topic's TimeStamp column is supposed to be updated to the current timestamp. However I attempted and failed.

 

I put the timestamp column on "ON UPDATE CURRENT TIMESTAMP", I set the column to NULL but seems to be at the same value. The column isn't null. I don't know if I should or shouldn't do that. I'm a complete newbie at MySql(~1Month).

 

Code: $sql = mysql_query("UPDATE `threads` SET `last_post_user_id` = '$id', `time` = 'NULL'; WHERE `id` = '$forum_id'");

 

Thanks.

 

[mikesta707]

Well, you are passing in the string NULL, since you surround NULL with single quotes, rather than the value NULL. But if you want the current time stamp, either not including the column time in the update query, stripping the quotes around NULL, or changing 'NULL' to NOW() should work