how to keep the previous date_time?

[Dcosta]

hi,
Through my php script user1 uploading files to mysql table and user2 login and correct that file & put grade for that file up to that the grade field is empty but my table having date_time field, it is indicating the uploaded date & time of user1. when user2 update that grade the date_time field also gets updated by the current time, but i didn't change that field through my query and keep the previous date_time. Please give some advice?
Thanks in advance. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[gilbert]

It looks as if the colums is probably a TIMESTAMP type with the ON UPDATE CURRENT_TIMESTAMP clause causing it to change whenever the row is updated. So try to change the timestamp definition to

columnname TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

here is more about the TIMESTAMP type: -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --