Jump to content
  • 0
Sign in to follow this  
glemor123

date registered CP & DB

Question

I 'am request for a query that would be inserted to my cp and database, login table. when a person registered at my cp then the database will record when that person registered. 

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

 

INSERT INTO login (register_date) VALUES(NOW());

 

Of course you need the register_date field (which is not present in base Hercules, you'd need to add it):

 

 

ALTER TABLE login ADD register_date DATETIME NOT NULL;

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.