UPDATEing

[Anon]

Hello,

Im building a message board and when people view a message I call the following MySQL statement to say its been viewed again...

$result = mysql_query("UPDATE messages SET numViews = (numViews +1) WHERE MessageID='$MessageID'");

The problem is, it also updates my date feilds with the current time, when it shouldnt.

DatePosted TIMESTAMP(14) NOT NULL,
EditedDate TIMESTAMP(14) NOT NULL,

does anyone know why? Thanks a million!

[Anon]

You should not use timestamp as data type in this case. Datetime is more appropriate.

Read the documentation at www.mysql.com