MySQl Timestamp... that works
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:
I know it is wrong. Please set me straight.
$sql = "INSERT INTO news SET
subject = '$subject',
body = '$body',
author = '$author',
date = DATE_FORMAT(CURDATE(), %m.%d.%Y)";
I'm going to go pass out now. Thanks for the help. :o