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

Converting RGB values to HEX
Code: <?PHP

$file_handle = fopen("colors/rgb.csv", "r");

wh

Images in email problem
I found this script for sending emails, it works but if the email has <img src="image.jp

pass form variables straight to email, no database required?
hello all,

im working on this form...

http://www.adobedayevents.com/project_request/pr

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

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

switch not getting value
what am i doing wrong?
i want to populate the country list according to the category
i want to

"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th

Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re