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.
-- Adam Alkins http://www.rasadam.com 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"; > > > Thanks, > > MAO > > > > -- > 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
