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

 

pinkangel_@hotmail.co.uk

 

[premiso]

In your INSERT query use the NOW() keyword in MySQL, to learn more about it google MySQL NOW().

[chris_s_22]

thx for your replys guys i ended up using this

 

// Get the current date
 $regdate=date("Y-m-d");
// And then this to store the information in the database
 $query = "insert into user (regdate) values (''$regdate')";

 

 

this works, just wanted to check with you guys if there was a reason why this was incorect or any reason why i shouldnt do it this way