mysql select last year
| From: | Martin Allan Jensen | Date: | Thu, 05 Dec 2002 08:02:24 +0000 |
| Subject: | mysql select last year | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23824@lists.php.net to get a copy of this message | ||
Hi all,
I have a little problem i know that you can help me with...
I have a mysql table
+----------+
| year | id |
+++++++++
| 2002 | 11 |
| 2003 | 11 |
| 2004 | 11 |
| 2005 | 11 |
| 2001 | 12 |
| 2002 | 12 |
+-----+-----+
And then i have a loop that takes the year and value for each of them. But how can i check if there
is for example a year for id 11 that is < than 2002
Thanks a LOT!
Regards,
Martin Allan Jensen