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

No comments posted yet

Your Answer:

Login to answer
65 Like 22 Dislike
Previous forums Next forums
Other forums

frame help
on the bottom frame is menu.html

Code: <body><form action='link.php' met

php - xml what is the best way to do this.
IN essence I want to have a script calling the info from the database.. I have no problem thus far,

cookie problem
I hv a website url
In this site main menu functionality based on cookie when user click on parti

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

Can't find the problem (no error message)!
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm g

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

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

Help with PHP and checkboxes
I am posting this for a friend of mine, i wrote a small script for her to process her form data to a

php require help needed
Ok i tried to use the search funtion but the word require is everywhere.

i'm really new to cr

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash