title: How to store multiple dates in mysql when starting date is known
body: <p>I am building a Scheduler in which it has 3 buttons -</p>
  
  <pre><code>Set A Reminder
  Schedule Daily
  Schedule Weekly
  </code></pre>
  
  <p>I have implemented the functionality of first button i.e details are successfully saved in mysql db and accordingly notification will pop up.</p>
  
  <p>But I have a query that how to write a sql query for 2nd and 3rd button given the current date .</p>
  
  <p>I have implemented 2nd functionality like </p>
  
  <pre><code>INSERT INTO schedulerDetails( userId,time) VALUES
  ( 'ankur',STR_TO_DATE('10/24/11 10:00 PM','%m/%d/%Y %h:%i %p') , ( 'ankur',    STR_TO_DATE('10/25/11 10:00 PM','%m/%d/%Y %h:%i %p'),
  ( 'ankur', STR_TO_DATE('10/26/11 10:00 PM','%m/%d/%Y %h:%i %p')), ( 'ankur',    'STR_TO_DATE('10/27/11 10:00 PM','%m/%d/%Y %h:%i %p')),
  </code></pre>
  
  <p>like this for all the seven days. But this solution is not feasible for this and also for 3rd button functionality. I want that if user has selected weekly button than except the time column all other fields automatically get copied and I do not have to mention ankur again and again and neither the date manually. Is there any way that the columns which are same gets copied in all rows and date is automatically generated for rest next 6 days based on today date.
  Is there any other way to perform the same thing while writing less code.</p>