Update modified timestamp in Dreamweaver and MySQL PHP database
Posted on 2010-11-14
Hello experts! I have an update page where I want the current timestamp updated in the database when the user presses the submit button. I have the update page and it's working (thanks to another expert in the Dreamweaver area). I have a hidden field that is set to update field [modified] in the database table.
My question is what do I put in the hidden field (called hiddenmodified) in the Value field? I'm trying now() and timestamp() but it's not working.
On the update record behavior I am telling Dreamweaver that this field is to update to [modified] field in database but I think I'm just not knowing what to put there in the Value field of the hidden field on my form.
In my table structure I have this set to timestamp.
Thank you experts!