Re: [PHP-DB] Inserting current date(MySQL)? From: 1LT John W. Holmes (holmes072000 <email protected>)
Date: 10/30/02

> I'm my trying to insert to current date from a php form? I know that
> MySQL has a CURDATE() fucntion and PHP has several date function, but I
> cann't seem to get either to work? Here is my existing code:

> $ADDDATE=date("Y-m-d");
[snip]
> VALUES ('$_POST[ADDDATE]',

You've got two different variables there. You should just use $ADDDATE in
your query.

Or, like you said, just use CURDATE() or NOW() in your query.

VALUES (NOW(), ...

VALUES (CURDATE(), ...

---John Holmes... 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php