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

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

how make 2 column in table with data tybe long row
hi every one

I want make in my table 2 column with data tybe long raw

how thi

Writing Windows Device Drivers with C
Yes: one of the nice features of C is void*. You can put anything there and get anything out. Very

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

Spaghetti Code
So.

I've pretty much reached the point where I have so many isset s on one page that I can't

Help Ordering Arrays
Hi, I have 3 arrays as shown below.

Code: $users = $this->get_latest_users();
$flir