RE: [PHP] Search Between Dates
| From: | Martin Lindhe | Date: | Tue, 16 Oct 2001 14:46:10 +0000 |
| Subject: | RE: [PHP] Search Between Dates | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-71219@lists.php.net to get a copy of this message | ||
> I'm looking to create a search function that can take a
> starting and ending
> date from a user, and compare that with other start and end dates in a
> database. I would like it to check if any of the days within
> the users start
> and end dates fall within any days in the start and end dates
> within the
> database.
Something like
SELECT * FROM table WHERE start_date >= table.start_date AND end_date <=
table.end_date
might do the trick
/Martin