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

recrawling
Can anyone suggest me how may i know a page is updated before it is being downloaded, so that i can

Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gri

The IE or FF detector
Hello Friends,

Problem of today ( we seek for php help ) as following ,

we know all th

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

Using Curl_multi for processing multiple URLs
Hi,

I am at a loss as to how to implement this. I would like to be able to automatically assi

JQuery, Masterpage, and Control issue
Hey everyone, I am using JQuery in several sites so I thought it would be best to place the library

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

random generation
hi

i need help with generating this

numbers from 1-12

i want to generate in ran

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a

Product categories for registration
Dear all,

We are going live with the Supplier registered next week. At standard, the 'sel