Hi

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.

Thanks