Datetime.. not sure if this is server issue

Databases
1

i have a php file that inserts ‘NOW()’ into a DATETIME column in my table (with other data) and it always turns up as 0000-00-00 00:00:00. The other stuff is working fine, though.
I’m running MAMP… does it have the server time set properly? I know that could be an issue, but assume it would be ok.

$qstring = “INSERT INTO tbl_members (member_id, member_lastname, member_date) VALUES (NULL, '”.$lname.“', ‘NOW()’)”;

2

you are not inserting the current time, you are inserting a character string

try taking the quotes off that you have around NOW()

:slight_smile: