If it is a unix timestamp, why not just select rows where the date is >= 7776000
(which is 90 days) or if you want to be specific about the months, use mktime()
to generate the timestamp for the date 3 months ago.
Quoting 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 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";
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php