Getting valie between two fields? (mysql)
select number from table where number < 30
order by number desc
limit 1
<>< Ryan
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 11:08 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
select number from table where number < 30
order by number desc
limit 1
<>< Ryan
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 11:08 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Getting valie between two fields? (mysql
> 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
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?
--
The above message is encrypted with double rot13 e