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

Error: SQL Syntax; Line 1
Code:

<?php require "global_settings.php"; ?>
<title&g

help retrieiving results and doing pagination
Having some trouble trying to get the results to show on more than just one page.

What is ha

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put

Array disappearing in foreach loop
Okay, I have this problem where an array will become undefined in a foreach loop.

Here is the

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad

Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I canno

Help with writing "$" with fopen
I just can't get my syntax correct. Could someone help me please? I am trying to write a connect fil

PHP - HTML
Could anyone give me some GOOD sample links for php - html email tutorial.

Thanks!

Preloading images
Posting this question here because I am not sure where this should belong.I am building an asp.net a