My date isn't working correctly.

[Anon]

I'm trying to have the current date entered automatically in a MySQL table. The field name is announcedate and its set to type timestamp.
In my function for adding an announcement, I have the following code: $announcedate = getdate();
$sql = "INSERT INTO announcements (announcedate, subject, details) VALUES ('$announcedate', '$subject', '$details')";

When adding a record, the date field shows all zeros. What am I doing wrong?

[Anon]

If you notice, getdate() returns an array. If you're using MySQL, you won't need a PHP function. Try using NOW().. i.e.:

$sql = "INSERT INTO announcements (announcedate, subject, details) VALUES (NOW(), '$subject', '$details')";

[Anon]

That worked. I could have sworn I tried that already. Thanks.