Inserting Date into MySQL DB using PHP

They have: 27 posts

Joined: Aug 2001

I have a datetime var in my MySQL database and would like to insert the current time using a built in PHP function or setting the default value as a built in MySQL funtion if possible.

I have to use phphMyAdmin for my MySQL database and everytime I type in Now() for the default it just sets the date to 0000-00-00 00:00:00.

Thanks,

Mark

They have: 27 posts

Joined: Aug 2001

Nevermind, I wrote NOW() instead of NOW('') Smiling

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.