I have a stored procedure that updates a table. In that procedure I’m using mysql interval. I have the interval amount as a variable which is a field in the table. I have due_date and recurr_days in the table. I can get SC to use the number defined in the recurr_days column as the interval amount and it adds that many days to the due_date. Problem is I can only get this to work on one record. I need it to go to each record and use the value in the corresponding recurr_days field as the variable in the interval. I’ve tried foreach and do-while loops but I really have no idea what I’m doing code-wise. Any suggestions?
