I apologize beforehand if I am near incomprehensible, it's 4 am and I have been staring at code for 5 hours now. What I need is an automatic timestamp added by mysql that returns the date like: 04.08.02 and only the date, not the time.

here is my very unfinished query, in it's PHP state:

PHP Code:
$sql "INSERT INTO news SET
       subject = '
$subject',
       body = '
$body',
     author = '
$author',
         date = DATE_FORMAT(CURDATE(), %m.%d.%Y)"

I know it is wrong. Please set me straight.

I'm going to go pass out now. Thanks for the help.