[RESOLVED] setting time and date

boombanguk

Hi,

I've just realised my TIMESTAMP is updating all the time no matter what query i do, but thats not what I want. I want to store the date/time when I first insert an entry.

I know this is pretty straight forward, but I'm just learning this stuff! 🙂

I read that the 2nd TIMESTAMP field is ignored, but how do I set this to the current date/time when an entry is made?

boombanguk

nemonoman

INSERT INTO mytable
SET alwaysChangingTimestamp=NULL,
recordCreationTimestamp=NOW(),
someOtherField='12345'

UPDATE mytable
SET someOtherField='99999'

on UPDATE recordCreationTimestamp will NOT be updated to current time of update, alwaysChangingTimestamp WILL be updated.

boombanguk

er..my current query is this

$query = mysql_query("INSERT INTO $table (title,link,type,email,description) VALUES ('$titleText','$urlText','$entryType','$email','$descText')");

how would I incorporate yours into that?

nemonoman

Well, you if you already have a timestamp column that is capturing update timestamps, you would
explicitly create a second new column, type TIMESTAMP or DATETIME, called IncepDate or RecordCreationDate or whatever

Then ("INSERT INTO $table (title,link,type,email,description, IncepDate) VALUES ('$titleText','$urlText','$entryType','$email','$descText', NOW())");