G glemor123 New member Messages 287 Points 0 May 12, 2014 #2 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.
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.
J Jguy Retired Staff Messages 292 Points 0 Age 38 IRC Nickname Jguy Github jguy1987 Emulator May 15, 2014 #3 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): Code: ALTER TABLE login ADD register_date DATETIME NOT NULL;
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): Code: ALTER TABLE login ADD register_date DATETIME NOT NULL;
