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

Change Web page language
i doing this thing first time but i dont find any suitable solution for it. On the demand of user. I

difference between datetimes
($row['totime']-$row['fromtime'])/60

this is giving me 0

example of totime and fromtim

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

Help with php code
Hello, can anyone tell me why this php word trap fails to work,
and the trigger words get blow r

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g
I am investigating how to run a Java stored procedure in multithread mode.
I know that if I chang

Lining up columns nicely.
Hello everyone, I'm having problems with making columns line up properly. Here is my code:

* Gridview and Detailsview in UpdatePanel, insert mode problem
I have a GridView and DetailsView working together. When a record from Gridview is selected, Detail

how to transport the Query and insfoset
Hi

I have created the query using SQ01........
How to created T-code for query..