I am trying to add information into a MySQL database from an online form. In certain instances i need to add 1 to the date variable i have. I cannot figure out how to incorporate this into my $sql variable. This is what i currently have:
$sql = "insert into rides values ('','".$SESSION['customerID']."','DATE_ADD(".$SESSION['rideDate'].", INTERVAL 1 DAY)')";
This however ends up inserting the $_SESSION['rideDate'] as is into the database, and doesn't add the 1 day.
If this is not possible, does anyone know of a php function that would add 1 day to a date in the format YYYY-MM-DD?
