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

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

Needing Youtube thumb nail fix.
I have a script on a site that pulls in you-tube videos,
The problem is, that the thumb nails for

admin with my register system?
Hey i wana make it so i can make a admin level on my register system , I'm kinda new to php to im no

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

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

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

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

serializing objects - loses methods - the point being?
Hi

I know that serializing an object will lose the methods. But whats the point in that? What

Embed Video Problem
Hey, thanks for looking!

File to be embedded:

Code: <playlist version="1&q