Sending time stamp on
Ok. Here's another one. Not sure if I should open a new thread so here goes.
I have a field for registration date in the client table. It's set to timestamp. After creating the registration form, there is no option for timestamp to send to the field in the insert record option so it gives me a null rather than a date and time.
I found this"
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "WAATKRegistrationForm")) {
$insertSQL = sprintf("INSERT INTO Clients (fk_country_t_country_id, ClientEmail, ClientPassword, ClientName) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['ClientLocation'], "int"),
GetSQLValueString($_POST['ClientEmail'], "text"),
GetSQLValueString($_POST['ClientPassword'], "text"),
GetSQLValueString($_POST['ClientName'], "text"));
Which I understand to be the server behavior that takes care of that and see nothing there mentioning this null value being sent. How can I get the timestamp in there?
jc