timestamp field is 00000000000000 after update??

[anders2000]

Hi there guys,

I have a very anoying problem with my mysql database... Then thing is that when I update an entry in the database (using the LawnGnome database abstraction layer) the timestamp column (which is a timestamp(14) type) is set to 00000000000000 instead of the current time. Do you guys have any idea on how to get this date right? I have been lookin through the forum and the only thing I have found is that it is supposed to be updated automagically when I update the entry, but it doesnt!

Cheers,
anders

[George_W__Bush]

I am not sure about why you have the 0 value.

Perhaps, try getting the server time - to whatever detail you like - then input that variable into mySQL after an edit is done - I am assuming the update is done through a PHP page.

$today = date("l, F j, Y, g:i a");

[Norman_Graham]

Have a look at this, anders: http://www.mysql.com/doc/en/DATETIME.html

The method of updating is important - I had this problem until I realised that I was resetting TIMESTAMP to 00000000 myself in my LOAD DATA INFILE files.

Norman