I have looked everywhere, I've figured out how to add x amount of days to the current date, or take away x amount of days from the current date. But let's say I have a date stored in my database as "0000-00-00", that is not the current date. How can I take that date and add a certain number of days to it?
I'm using php with a mysql database. I did find one sql command that works when I run it in the sql command line, but not on php. It's
SELECT DATE_ADD('$mydate', INTERVAL 14 DAY) Of course in the command line I put an actual date in the $mydate portion. But in php, it looks like this:
$next_date=mysql_query("SELECT DATE_ADD('$mydate', INTERVAL 14 DAY)"); $mydate is just a date in the form 0000-00-00 pulled from somewhere else in my database. But it keeps spitting out "Resource id #8."
What's a simple way to add some days to a given date?