Storing the current date when a user registers?

[Solarpitch]

Hi Guys,

Basically, what I am trying to achieve is add the current system date to a table in the database along with a user's details so I know when they registered!

Do you know how I would declare the table? I tried

[code]
cur_timestamp TIMESTAMP NOT NULL
[/code]

... but that doesnt work. Also how would it look in the insert statement?

Cheers!

[jwk811]

you can use the now() function to do this.. heres an example of what your php query might look like to do this..
[code]INSERT INTO users (name, password, regdate)
          VALUES ('$username', $password', NOW())";[/code]
hope this helps!