MySQL Date Fields like to receive the date in the following format:
yyyy-mm-dd hh:mm:ss
you should use the following code:
<?php echo date("Y-m-d H:i:s"); ?>
If this is on an insert, you can set the default value for the date column to:
NOW()
in the database, this will automatically add the currant date when a record is inserted.