MySql Script

I need to have a script/query written to insert records into a mysql database based on the day of the week and time of day. For example: it should run for from today through 12/31/2014 If the day of the week is Mon, Tues, Weds, or Thursday do this: Increment = 0:06 for tmpTime = 7:00am to 8:30am insert into reservations (res_time) Values (tmpTime) tmpTime = tmpTime + increment next tmpTime // once that completes you switch the increment time to 15 minutes Increment = 0:15 for tmpTime = 8:30am to 5:30pm insert into reservations (res_time) Values (tmpTime) tmpTime = tmpTime + increment next tmpTime Once it does the Mon-Thursday inserts, it should then do Fri, Sat and Sunday insert which is the same code, but the times will be adjusted slightly.. Instead of 7:00 to 8:30 am for the first part, it's 7:00 - 9:00.