Paul, In your purchase table, do you have the exact date when the equipment was purchased? If that is the case, then you do not need the additional year table, your original table already consist of that information.
/Peter -----Original Message----- From: Paul Goepfert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 10:45 AM To: Peter Lauri Cc: php-general@lists.php.net Subject: Re: [PHP] Is this the most effient to do with php an mysql? I am using this table to find out what year the person purchased their equipment On 2/6/06, Peter Lauri <[EMAIL PROTECTED]> wrote: > I do not know if it is more efficient, but you can do this: > > $year = date("Y"); > $Query = sprintf("SELECT y_id, year FROM Year WHERE year <= %s ORDER BY year > DESC;", $year); > $Result = mysql_query($Query); > > May I ask you what you are using this table for? > > /Peter > > -----Original Message----- > From: Paul Goepfert [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 07, 2006 7:55 AM > To: php-general@lists.php.net > Subject: [PHP] Is this the most effient to do with php an mysql? > > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
