2 Dec 2006 at 22:12 #1 Wimnat Wimnat Associate Joined 19 Jun 2006 Posts 162 Location Swansea, Wales When i submit a form to my mySql db with php i want to datestamp the entry in the format 2006-12-02. Is it best to use the php function to get the date first or can you use mysql to add the date on entry?
When i submit a form to my mySql db with php i want to datestamp the entry in the format 2006-12-02. Is it best to use the php function to get the date first or can you use mysql to add the date on entry?
3 Dec 2006 at 15:50 #3 Wimnat Wimnat Associate OP Joined 19 Jun 2006 Posts 162 Location Swansea, Wales I tried this... INSERT INTO mbs_table dateadded VALUES (CURDATE( ) ) but got an sql error. Any ideas?
I tried this... INSERT INTO mbs_table dateadded VALUES (CURDATE( ) ) but got an sql error. Any ideas?
4 Dec 2006 at 19:04 #6 Wimnat Wimnat Associate OP Joined 19 Jun 2006 Posts 162 Location Swansea, Wales Cracked it... had to use SET rather than INSERT
