Date problem

[keyser_soze]

I'm having a problem inserting the date, without the user physically writing it in, into the MySQL Database.

I'm making some sort of a news thing, where a user writes news, and it shows up on the index page. My problem is, all of my dates come out as december 31, 1969.

I used NULL for the date, and i've also tried setting $news_date to the date() function, then inserting that. None seemed to work for me.

Here is a look at the code:

$query = "INSERT INTO pfmnews(news_id, news_headline, news_content, news_contact, news_email, news_date) VALUES(NULL, '$news_headline', '$news_content', '$news_contact', '$news_email', NULL)";

Any thoughts? Thanks --

[[deleted]]

If this is mysql, use the NOW() function:

$query = "INSERT INTO pfmnews(news_id, news_headline, news_content, news_contact, news_email, news_date) VALUES(NULL, '$news_headline', '$news_content', '$news_contact', '$news_email', NOW())";

[keyser_soze]

yea, that doen't seem to be working either

ii'll check my other code to see if i messed somethign up there, but i'm pretty sure i didn't.

[keyser_soze]

yea, i don't think i did anything else wrong

any other ways?

[keyser_soze]

never mind,.. i got it working. I had set up my table incorrectly (stupid me)

thanks though,... i never knew about the now() thing