MySQL's now() +1 day

You can use:

NOW() + INTERVAL 1 DAY

If you are only interested in the date, not the date and time then you can use CURDATE instead of NOW:

CURDATE() + INTERVAL 1 DAY

sql mysql datetime

better use quoted `data` and `date`. AFAIR these may be reserved wordsmy version is:

INSERT INTO `table` ( `data` , `date` ) VALUES('".$date."',NOW()+INTERVAL 1 DAY);

sql mysql datetime

Try doing: INSERT INTO table(data, date) VALUES ('$data', now() + interval 1 day)

CodeHunter