Return count between timestamps

Hi

I have a car parking reservation table that stores 2 timestamps - entry_date
and exit_date.

There is a maximum number of car parking places, and I want to check that on
each day between the 2 requested reservation dates, the count of the
existing records does not exceed the maximum.

So I need some 'elegant' system of getting a count of all the existing
bookings for each of the days between the entry date and the exit date.

Unfortunately I have no idea how to GROUP by the dates between..

SELECT COUNT(id) as num_places FROM reservations r WHERE (('$entry_date' >
r.entry_date) AND ('$entry_date' < r.exit_date)) OR (('$exit_date' >
r.entry_date) AND ('$exit_date' < r.exit_date));

This obviously only returns the sum total - is there anyway I get this on a
day by day basis?

Many thanks

Jonathan

- - - - - - - - - - - - - - - - - -

Nixon.
+44 (0)1736 758600

www.nixondesign.com

White's Warehouse
Foundry Square
Hayle
Cornwall
TR27 4HH UK