Re: Getting valie between two fields? (mysql)
| From: | 1LT John W. Holmes | Date: | Wed, 16 Oct 2002 17:22:58 +0000 |
| Subject: | Re: Getting valie between two fields? (mysql) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22464@lists.php.net to get a copy of this message | ||
> I have a table something like this:
> __________
> | id | number |
> | 1 | 1 |
> | 2 | 23 |
> | 3 | 59 |
> | 4 | 103 |
>
> If I have a number, say 30, I need to get the last number it's above -
> in this case id 2. Any ideas?
$number = 30;
SELECT id FROM table WHERE number < $number ORDER BY number DESC LIMIT 1;
---John Holmes...