title: how to set timestamp in the future
body: <p>I have a question on calculating times.</p>
  
  <p>I have a simple table filled with 3 columns. column 1 will be passed by NOW() in the VALUE. The second column should be the NOW() timestamp plus 14 days. I never used timefunctions before, so I do have some understanding problems. </p>
  
  <p>So is it possible when I have:</p>
  
  <pre><code>$copy = "INSERT INTO table (a, b, c) VALUES (NOW(), $var_for_b, $var_for_c)";
  </code></pre>
  
  <p>to use for</p>
  
  <pre><code>$var_for_b 
  </code></pre>
  
  <p>easily </p>
  
  <pre><code>NOW()+14d
  </code></pre>
  
  <p>or do I have to set a variable with a time/date function? </p>
  
  <p>in case of using a variable what can I do there?</p>
  
  <pre><code>$in_14_days =mktime(+14d)
  </code></pre>
  
  <p>and my third column should simply be the difference between the NOW() and the NOW(+14d).</p>
  
  <p>I'm sorry for this question but there are so many timefunctions that I do not guess the differences between them.</p>