Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Using a hidden field to enter the current date when a record is updated (PHP / SQL)

View all replies to this thread

Using a hidden field to enter the current date when a record is updated (PHP / SQL)

Thread began 7/08/2015 10:42 am by iain331081 | Last modified 7/08/2015 2:13 pm by iain331081 | 388 views | 1 replies

7/08/2015 10:42 amiain331081

[RESOLVED] Using a hidden field to enter the current date when a record is updated (PHP / SQL)

I know you can use a timestamp to do this, but I am already using that for LastUpdated, and I think SQL only lets you have one?

So I have a hidden field in my form, and have tried:

<input name="2016_Registered_Date" type="hidden" value="<?php echo date();?>" >

With no luck, so added some a date format:

<input name="2016_Registered_Date" type="hidden" value="<?php echo date('j F Y');?>" >

It seems to get the day and month, but not the year, eg 8 July 6638

Any suggestions what else to try?

Thanks.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.