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

Problem executing bash script using shell_exec
Hi there,
I created a bash script file using following code to convert doc documents to pdf using

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

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

classic dynpro : hide area and auto adjust hights
Hi,

I want to develop a similar user interface as is used in standard transaction MIGO.

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

Help with PHP Calendar code...
Hello, I'm new to this forum and I'm glad I found it.
I wrote this code for a PHP calendar as an

Need a Timecode Class...
Not a Time Stamp, Time Code. Format is a bit different. HH:MM:SS:FF where FF is Frames. I dont re