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

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

Header redirect
Hello ive got a problem ive got form with its action set to itself.
Code: <form id="f

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that

Get content from table into a list, without repeating.
Alright this is kinda an odd thing, so I need some help.

I have a table "quote" wit

Email Form Syntax Issue
I need the TO: in email to display To: CEO instead of To: abc@mail.com

How to alter the scri

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

php and downloading
I want to use a php script to create two files. Then I want it to redirect (or whatever) to have tho

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

Checking if multidimensional array is empty?
I have a for with multiple test input fields. Specifically the user submits multiple names and ages