WeirdMystery Posted December 26, 2009 Share Posted December 26, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/186363-timestamp-column-problem/ Share on other sites More sharing options...
mikesta707 Posted December 26, 2009 Share Posted December 26, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/186363-timestamp-column-problem/#findComment-984163 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.