updating timestamp.

[Mikaela]

When I update something in an entry, its timestamp gets renewed to the time of the update. How do I prevent this? I am currently doing stuff like this in PHP:

$sql4 = "update blog set views = views + 1 where ID = $threadID";
$result4 = @mysql_query($sql4, $conn) or die("Could not post thread. <a href=\"$link\">Try again.</a>"); -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Ivy]

It is the default behavior of a TIMESTAMP column. Prior to 4.1 that was pretty much the only behavior. Starting in 4.1 you have the option of designating TIMESTAMP columns to be set the current date/time initially. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --