Re: amount of overlaping dates
| From: | David Otton | Date: | Thu, 03 Dec 2009 14:08:19 +0000 |
| Subject: | Re: amount of overlaping dates | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-300241@lists.php.net to get a copy of this message | ||
2009/12/3 Merlin Morgenstern <merlin_x@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.