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

array help
Does anyone know how to require 10 text fields for individual grades and output class average? (10 p

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

Suggestions for Functional module
Hello experts,
I Have done B.Sc(Mathematics) and MCA & have learnt SAP/ABAP but do n

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

Unique Visitor Tracking
Hello. Currently, I run a voting site where voters are tracked by their IP address and can only vote

Easy administration on MySQL databases
My website is database driven and I am very tired of manually making queries to my tables in order t

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

Displaying values from a SQL count...
Hi,
Easy enough question i just forget the exact method ..
I have ...

Code: //count win

PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg