This topic is locked

modified date and created date

8/11/2005 11:10:19 AM
PHPRunner General questions
lukey author

Hi,
i have a record that has two fields modified date and created date.
my database has 2 columns - both timestamp.
i read somewhere that mysql is able to update both fields when they are empty
and update only one when there is a entry inside.
as my fields are rather self explanatory how do i go about doing it in phprunner?

admin 8/12/2005

Hi,
you can try the following:

Open Formattingtab in PHPRunner, select Edit as type "Hidden" for Created and Modified fields. Then click Edit format and enter now() as default value for both fields.

Then remove Created from Edit page.