registration date added to registering

[chris_s_22]

what i want to achieve is that when people sign up i want to have the date entered into my database

so far all i done is create a regdate feild to the database the "type" i used is "date"

not sure what the code would be, please help or direct me to a tutorial that explains how and what to do

[Weedpacket]

Presumably you have an insert statement putting the new registration into the database. The value you want to add is

"VALUES(......, '".date("format")."', ....)"

where format is a string of whatever pieces from the table on the [man]date[/man] page will give a string in the format used by your DBMS.

[dagon]

NOW() would be an easy choice

[bradgrafelman]

Although the OP didn't sate which DBMS is being used, an even easier solution when using MySQL might be a TIMESTAMP column, defined like so:

reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP

That way you wouldn't even need to include the 'reg_date' field in your INSERT queries when adding new users to the database - the DBMS takes care of populating that column automatically (similar to an AUTO_INCREMENT column).