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

PHP Form to Variable.
Hi! I have written a HTML-form code in DreamWeaver CS3 (in a PHP doc) and I really need it to work s

Error In Syntax
I got this error:

Code: Parse error: syntax error, unexpected '>' in /home/bucket/publ

problem with GROUP BY and ORDER BY
i usually use this query to display the last 10 entries from a sql table:

Code: $query = &quo

How to clone an SAP ECC using bacup tape on z/os?
We want to clone our production to a different SID using backup tape.

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

some query on multilingual website
Hi all,

Which is the simplest and easiest method to make a website multilingual,
is it put

Access database inside of a validation class
Hello,

For quite some time, I have been using functions to validate form input and access the

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea