How to add Timestamp from Hidden Field

I have created an Insert Record form using DA. There are four fields -- three text fields (e-Mail, First_Name and Last_Name) and a hidden field (reg_Date). All the corresponding columns in the db are not_null. When I run the form I get the error "Incorrect integer value: '' for column 'reg_Date' at row 1" -- this is (I presume) because there is no value currently assigned to the hidden reg_Date field. The Insert function obviously fails.

The reg_Date column is data-typed to int (I planned on using the Unix timestamp). What code do I place (presumably in the hidden reg_Date field) to pass the correct value to the Insert code??

Thanks,

Mike

set the value of the hidden field to:
<?php echo time(); ?>

That was too easy. . .

:)

Thanks, Jason. . .

you're welcome.

I'm trying to get this to work following the thread here. I have put <input id="HiddenFields_fields" name="HiddenFields_fields" type="hidden" value="<?php echo time(); ?>" /> into my form. The SQl is

`Date Added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

Yet it still adds the date as 0000-00-00 00:00:00 in the Date Added column.

a datetime field in MySQL expects the date to be passed as yyyy-mm-dd hh:mm:ss, not a time stamp.

change the value of the form element to:
<?php echo date("Y-m-d h:m:s"); ?>

Originally Said By: Jason Byrnes

  a datetime field in MySQL expects the date to be passed as yyyy-mm-dd hh:mm:ss, not a time stamp.

change the value of the form element to:
<?php echo date("Y-m-d h:m:s"); ?>  

So should it be

$WA_fieldNamesStr = "RegionName|IntroText|Content|Photo|Title|Price|DateAdded";
$WA_fieldValuesStr = "".((isset($_POST["Region"]))?$_POST["Region"]:"") ."" . "|" . "".((isset($_POST["IntroText"]))?$_POST["IntroText"]:"") ."" . "|" . "".((isset($_POST["Content"]))?$_POST["Content"]:"") ."" . "|" . "".((isset($_FILES["Photo"]))?$_FILES["Photo"]["name"]:"") ."" . "|" . "".((isset($_POST["Title"]))?$_POST["Title"]:"") ."" . "|" . "".((isset($_POST["Price"]))?$_POST["Price"]:"") ."" . "|" . "".((isset($_POST["<?php echo date("Y-m-d h:m:s"); ?>"]))?$_POST["<?php echo date("Y-m-d h:m:s"); ?>"]:"") ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|',none,NULL";

change:
<input id="HiddenFields_fields" name="HiddenFields_fields" type="hidden" value="<?php echo time(); ?>" />

to:
<input id="HiddenFields_fields" name="HiddenFields_fields" type="hidden" value="<?php echo date("Y-m-d h:m:s"); ?> " />

Awesome! Sorry for being so dumb earlier. I think I was just tired and hungry :o.

Would like to know how to display that date on a page in format Day - Month Year. At present I have <?php echo $row_DetailRS1['DateAdded']; ?> Not sure how this works.