2. PHPRunner General questions
  3. Creation date and update date
This topic is locked

Creation date and update date

 		6/4/2008 7:59:16 AM
PHPRunner General questions
P
 Peter de Jong author

Hello,
I am a beginner in working with mysql en phprunner (and also this forum). So maybe my question is very simple.
I want to store both the creation date and the date when a record is updated in a table.
At the moment the field are in the add-pages with the function now() in default value. That works but u user can edit the date, so that not good. The same applies to the update date.

I also tried to work with timestamp. That works fine for one date but not for two dates. Can you tell me what the best solution is to solve my problem.
J
 		Jane 6/4/2008

Peter,
set up these fields as readonly on the "Edit as" settings dialog on the Visual Editor tab. Also use Now() as default value for both fields and [b]Apply on the Edit page as well option for the field where updated date is stored.
P
 		Peter de Jong author 6/4/2008

Thanks Jane,
This works well on the first date when a new record is created. When I update the record instead of only the date also the time is displayed. When I save the record nothing is saved. In the view as tab I have selected short date. I have selected the same on the creation date.

Peter,

set up these fields as readonly on the "Edit as" settings dialog on the Visual Editor tab. Also use Now() as default value for both fields and [b]Apply on the Edit page as well option for the field where updated date is stored.
J
 		Jane 6/5/2008

Peter,
It's difficult to tell you what's happening without seeing actual files.

Please send screenshots with your PHPRunner settings and a detailed description of what you're doing to support@xlinesoft.com.