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

downloading a file as HTML
Hi.
I'm rather confused with forcing a download. I just want to save dynamic content (from $_SESS

is_dir() problem
Hello,

I'm buidling a php scripts that dynamically get's subfolders from a specific folder.

imap: how to save a copy of sent emails to sent elements
Hello my friends,

I am writing an online emailing application with inbox outbox/sent elements

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

having a small php error tha deals with the 'foreach'
Last night i was working on a script for a cart and it seemed to working good, until this morning. F

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

Login logout link help
Hi all,

Im new to php and Im having trouble creating a login/logout link for my page that dis

Price in PR
Dear Experts,
Why we have to enter the price in the PR, and why there is no free goods indicato

how to make database item unique
Hey guys,

is it possible to do this:

I have the database item $title being pulled for

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i