[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] Inserting current date(MySQL)?
From:       "1LT John W. Holmes" <holmes072000 () charter ! net>
Date:       2002-10-30 19:11:52
[Download RAW message or body]

> 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

[prev in list] [next in list] [prev in thread] [next in thread]