I need to INSERT tomorrows date....

From: Date: Mon, 09 Oct 2000 10:38:35 +0000
Subject: I need to INSERT tomorrows date....
Groups: php.db 
Request: Send a blank email to php-db+get-3427@lists.php.net to get a copy of this message
Hey.. I am developing a news portal for a newspaper, and one of the desired functions here is that the reporters want to be able to put in articels that will not appear on the web until the day they want it to be "published" I`ve been experimenting with DATE_ADD(NOW(), INTERVAL 1 DAY) in the INSERT command, but this only returns a null value in the date field. I was kind of hoping that I wouldn`t have to do a SELECT DATE_ADD(NOW(), INTERVAL 1 DAY command , and then insert this result into the INSERT command... I wonder what I am doing wrong... 1. Is it possible to insert the DATE_ADD command with MySQL (And I`ve been having som typos in the command) or is there some other way of doing this?? Pls help me...

« previous php.db (#3427) next »