Limit
| From: | Marie Osypian | Date: | Mon, 04 Aug 2003 17:28:02 +0000 |
| Subject: | Limit | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29663@lists.php.net to get a copy of this message | ||
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'
ORDER BY date DESC
LIMIT 5";
Thanks,
MAO