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

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

Need help/w Page: 1,2,3,4 function!
So I have this code im working on where it's ment to display seperate pages having 20 logs each
I

Display thumbnails as square while retaining aspect ratio
I am trying to figure out a way to make an image display as a square, for example 80x80 pixels, when

Help: problem with Headers to download PDF file
Hi,

I'm trying to implement a script where when a user clicks a link he gets a PDF file to op

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do

Format timestamp from mysql
When I tried this:
Code: date("m/d/Y H:i A", $row['timestamp'])
I got 12/31/1969 18:

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c