Re: Limit
| From: | CPT John W. Holmes | Date: | Mon, 04 Aug 2003 18:22:04 +0000 |
| Subject: | Re: Limit | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29667@lists.php.net to get a copy of this message | ||
From: "Marie Osypian" <mosypian@savingforcollege.com>
> I don't want to use the limit on this query anymore. What I want is to
> display all that are dated within the last 3 months. What would be the
easy
> way to do that?
>
>
> SELECT federal_development_id, UNIX_TIMESTAMP(date) AS date, topic, body
> FROM federal_developments
> WHERE pro_solutions = 'Y'
AND date > CURDATE() - INTERVAL 3 MONTH
> ORDER BY date DESC
";
---John Holmes...