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

PHP onsubmit in the form not going to the fuction.
I have a form through ‘onsubmit’ calling a function validation(). But not going to the

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

if php cookie set, show code...
Hi all.. I need to figure out this little snippet right quick.. seems like it should be easy enough

PHP Code To Change Font Color in Table Cell
I would appreciate help with the following snippet of my php code. I am just trying to change the f

simple php table loop
Hi all,

I've the following code

<?php // Create category options

How do i do multi uploads?.
Hey i would like to do this : http://hosting.mrkrabz.net/

I've got the base down you can uplo

Batch Related Pricing
Hi, I need some clarity on the batch related pricing

For example the following are the b

is_dir() problem
Hello,

I'm buidling a php scripts that dynamically get's subfolders from a specific folder.