I am currently developing an admin section for a website I have created. I am using the following code to update the database if the user wishes to change something, in this case the title of a news item:
mysql_query("UPDATE news SET news_text = '".$HTTP_POST_VARS['text_update']."' WHERE news_id = '".$HTTP_POST_VARS['news_id']."'");
The problem I have is that whenever I make a change to a row in the database, the timestamp field is updated as well.
As this is a new section, the date should remain constant. I understand I could simply grab the current timestamp and re-insert it but surely there is an easier way?
