RE: [PHP] between date
| From: | Jay Blanchard | Date: | Tue, 18 May 2004 12:10:52 +0000 |
| Subject: | RE: [PHP] between date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-186469@lists.php.net to get a copy of this message | ||
[snip]
I have a table whereby I use the php date() and time() function.
I retrieve the data etc, no problem.
but I now need to perform a query of between dates.
Is there a function or method to perform this.
[/snip]
Use SQL 'BETWEEN' i.e.
SELECT items FROM table WHERE date BETWEEN this date AND that date
It is inclusive