looping a SQL insert statement with updating dates
new here because i am struggling massively lol.

What i need to do is run instert  the same thing into a database only changing the date.

i.e
NSERT INTO bs_events (eventDate,eventTime,title,spaces,description,entryFee,payment_required,max_qty,allow_multiple) VALUES ('2011-03-02 00:00:00', '10:00','Carpet Cleaner 3000','4','This is rad','25.99','1','1','2') [b][/b]

so i need to run this loop for a year or month or 2 years and have it add to the database but the date needs to change each day

I've got no idea how I go about making a script to do this so any help would be appreciated 

thanks

looping a SQL insert statement with updating dates
===

new here because i am struggling massively lol.

What i need to do is run instert  the same thing into a database only changing the date.

i.e
NSERT INTO bs_events (eventDate,eventTime,title,spaces,description,entryFee,payment_required,max_qty,allow_multiple) VALUES ('2011-03-02 00:00:00', '10:00','Carpet Cleaner 3000','4','This is rad','25.99','1','1','2') [b][/b]

so i need to run this loop for a year or month or 2 years and have it add to the database but the date needs to change each day

I've got no idea how I go about making a script to do this so any help would be appreciated 

thanks
