I had the following fields, with a single record and I want to populate base on start and end date, length and repeat every:

start_date = "08/03/09" (starts on)
end_date = "08/21/09" (ends on)
the_length = "1" (everyday)
repeat_every = "2" (with an interval of 2 days)

Now, I want to use SQL statement to populate the result "everyday" but with an interval of "2" days, starting from "start_date" up to "end_date".
I was able to solve the problem on the application side (using Array and lots of IF statements), but I know this can be solved using a single Query/SQL Statement or a Stored Procedure.

Thanks.

could you please do a SHOW CREATE TABLE for your table

it's sort of clear what you want to insert, but not really clear where you want to insert it