the date

troinfo

I have a hidden value for date in my code.
I\'m trying to capture the date that a user signed up. When i check the database it shows up as 0000-00-00. I know that is the format that sql wants and i have no problem with that but should i put in my code to pass the date?

I tried this in my code but no good
$date = date(Y m d);

Anon

The date format should be in string:

date("Y m d");

Diego

troinfo

actually it is i just forgot to put it in my post. But thanks for the input. 🙂

Anon

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME

You'll see there a section that says:
"You can specify DATETIME, DATE, and TIMESTAMP values using any of a common set of formats: "

That section will tell you what to put to submit to MySQL.

HTH,

Diego

Anon

Thank you soo much! You answered my question. So will that put a date of the client or the server? How could I take the date add 14 days to it and put it back in the DB? Thanks!
Chad

troinfo

I tried what you said and no good. I can display the date noprob but i can't seem to caputer it to put it into my database.

Anon

Good point neither can I. I just need it to add 14 days to it. 🙂
Chad

Anon

use timestamp() to get the current time, then add 14 days in seconds, i.e.
142460*60

and that's it.

It will be the time on the server.

Diego

Anon

what do you mean you can't capture it?

Diego

troinfo

when a person signs up besides all there other info I would like to have the date that they signed up on go into the database also.

Anon

So use the time() function to get the date and time...

Diego

Anon

I can't recall if MySQL is up to the task, but in some other DBMS there is syntax for date manipulation to do things like "add 14 days".