Re: Retrieve listings between two dates?
| From: | mqqla | Date: | Fri, 27 Oct 2000 08:37:25 +0000 |
| Subject: | Re: Retrieve listings between two dates? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3986@lists.php.net to get a copy of this message | ||
Try:
SELECT * FROM calendar WHERE Year < #2000-12-31# AND Year >
#2000-01-01# ORDER BY Start ASC
it's SQL92 standard and should work in any dbase
mqqla