TimeStamp Column Problem...

Posted on 16th Feb 2014 07:03 pm by admin

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

Your Answer:

Login to answer

Other forums

check how many commas the variable containing the query has between [i]select[/i
Hi...

iv made an sql table that contains id number - name of sql query and an sql query.
T

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

Spaghetti Code
So.

I've pretty much reached the point where I have so many isset s on one page that I can't

foreach loop, assistance request
I would like some guidance on the usage of foreach as I try to parse through a large database and wh

Consuming MII WebService in Java WebDynpro
Hello,

We are facing a strange situation...

We define a transaction in MII to

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d

SESSION CHECK WORKS "MOST" of the time... whats going on?
i have a sign in check thats included in every page that is a members only page which is basically a

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get