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 ajax - two drop down list with a submit button
i have created a form with 2 drop-down list and a submit button. I would like to know how to pass th

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every

Redistributing dependent dlls
Hai all ,

I have created an application in VC++ using VS2008 in a development machine which r

ORA-01017: invalid username/password; logon denied
Dear All,

I am facing problem in taken backup from db13 it comes up with the following l

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i

PEAR in appliactiond development
When I was picking up PHP I went from procedural programming, fairly quickly into OOP, then after wr

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m