title: How to do recurring dates with php/MySQL
body: <p>I have a table:</p>
  
  <pre><code>table Event
  - name
  - description
  - date (in format 2011-08-06 11:00:00)
  - id
  </code></pre>
  
  <p>I need to create <strong>recurring events</strong>.</p>
  
  <p>How can I best <strong>duplicate a row</strong> with mostly the same data (name, description) but change the date?</p>
  
  <p>Say, if I have an event that occurs August 6th, I would like to create three more events on
  - August 13, 20, 27 (every Saturday)</p>
  
  <p>Also, is this something better accomplished with a mySQL query? I am guessing so because of the format the date is in...but any advice would be appreciated.</p>