Updating without changing timestamp...

Anon

I'm coding a forum using PHP and MySQL. Unfortunatley, every time I "edit" a post message and use UPDATE to modify the message the timestamp for that record changes to the timestamp of the edit. How do I prevent this? 😃

Anon

I could be miss'n the mark, but, could you set the timestamp as the value of a cookie on the client befor the user hits the sent button? Then you could set the variable in the update statement to the value of that particular cookie.
Each time the user entered a new statement the old cookie could be overwritten with the value of the new one.

Du'know, just a guess 🙂

Anon

We can't tell you unless you provide us with code...

Diego

Anon

-lol-

mysql_query("UPDATE " . $POST_TABLE . " SET message='$message' WHERE postid='$postid'")

there's the code... I don't think it will help much. For whatever reason, when I run that query, the timestamp WHERE postid='$postid'" changes to the timestamp for when the edit took place. I want to keep the original posting timestamp, not have it switch. I didn't, as you can see, say update post_table set timestamp=now...

Anon

if your timestamp column is set to null when you setup the tables, it will change when you edit the record.

one solution is to change the column to NOT to default to null. thus, you will have to insert into this field the first time the record is created. then subsequent upddate will not change the timestamp.

second solution is to reinsert the timestamp during the update. thus, you will need to retrieve the timestamp when you are ready to update the record. then in your update statement, you will need to add timestamp = $old_timestamp or something similar.

Anon

Ah ha! I knew it was something simple. I should of known it was the NULL thing. Thanks Kai.