2009/12/3 Merlin Morgenstern <merli...@fastmail.fm>:
> I am searching for a way to identify the amount of simultanious date ranges.
>
> Example:
>
> array start=('1.12', '5.12', '9.12');
> array end =('8.12', '12.12', '16.12');
>
> Looks like this in a table:
> start end
> 1.12 8.12
> 5.12 12.12
> 9.12 16.12
>
> Obviously the first and last daterange do not overlap. So the amount of
> overlaping bookings is 2. But how to identify this with PHP?!
Store the start and end times of each event in an SQL table.
SELECT COUNT(*) FROM `event` WHERE `start` <= NOW() AND `end` >= NOW()
gets you the number of events that are happening right now.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
