title: How do I get next month date from today's date and insert it in my database?
body: <p>I have two columns in my db: <code>start_date</code> and <code>end_date</code>, which are both <code>DATE</code> types. My code is updating the dates as follows:</p>
  
  <pre><code>$today_date = date("Y-m-d");
  $end_date = date("Y-m-d"); // date +1 month ??
  
  $sql1 = "UPDATE `users` SET `start_date` = '".$today_date."', `end_date` = '".$end_date."'  WHERE `users`.`id` ='".$id."' LIMIT 1 ;";
  </code></pre>
  
  <p>What is the best way to make <code>$end_date</code> equal to <code>$start_date</code> + one month? For example, 2000-<strong>10</strong>-01 would become 2000-<strong>11</strong>-01.</p>