using mysql is better then using php.
SELECT y_id, year FROM Year WHERE year <=  year(curdate)
ORDER BY year desc;

Paul Goepfert wrote:
Hi all,

I have a table of years going from 1985 - 2008.  These years represent
the purchase year.  I have created a SQL statement that selects the
years that are available for purchase years. For example 2006 -1985. Here is the SQL statement I created to produce that output.


SELECT y_id, year FROM Year WHERE year <=  extract(year from now())
ORDER BY year desc;

Is there a more efficient way to do this using more PHP and less mysql?

Thanks

Paul


--

life is a game... so have fun.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to