Ive scratched my head over this and come up with nothing.
I need to add a row to a table for each date supplied on a booking form between date limits.
The table is simple
name = Bookings
fields =
ID
Date (mysql format)
Booking_Ref
Class
Cat
obviously I could just loop through the dates and insert one row per date, but thought there must be a way to do this within MySQL without the dreaded loop.