From: "Marie Osypian" <[EMAIL PROTECTED]>
> 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
> 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php