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

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

iterating through an array and escape each value independently.
I have a set up where the variable being escaped is an array and it needs to be iterated and escaped

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

Page Reload
I am having issues getting a page to reload after I submit data to a database. This form should inp

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t

tell csv import script to ignore blank rows?
Hi i have the below script but i get an error if a row is blank ie a return in the csv file at the e