[Clark_Kent]

Hi Everyone,

I have a form that submits data into a database with the use of PHP. I have a hidden form element that I created in order to input the current date and time into the database using the now() function once the form has been submitted (i'm using MySQL). The problem i'm experiencing is when the form has been submitted and the necessary form data is placed into the database, the datetime field is set to zeros instead of the current date and time - it displays 0000-00-00 00:00:00.

Input field looks like this...

Code:

<input type="hidden" name="dateJoined" value="now()"  />

The corresponding PHP code that deals with this specific control is the following...

Code:

GetSQLValueString($_POST['dateJoined'], "date")

The PHP code above i took out of the VALUES part of the SQL query. I know something is being sent to the datetime field in the database because it displays a series of zeros, I'm just not sure why it doesn't accept the current time and date from the now() function. When i enter the following query...

Code:

UPDATE databaseName.tableName SET dateJoined = now();

the above works, it updates the datetime field with the current date and time. So at least the now() function does input the correct data.

Any idea what I'm doing wrong?

Thanks for your time,

- CK

[mab]

I'll give it a guess, try any or all of the following -

now() is a mysql function. It only has a meaning and only results in a value when it appears in a mysql query.

Your GetSQLValueString(..) function is a user defined function. To get any help with what it might be doing, you need to post the code for it.

We would need to see the query string that results when the form is submitted in order to help.

[flann]

Instead of passing the date through a form, when you do your insert statement try.

INSERT INTO tablename (dateField)
VALUES (CURDATE())

I like to spread the love between php and the database.