Getting valie between two fields? (mysql)

From: Date: Wed, 16 Oct 2002 17:08:10 +0000
Subject: Getting valie between two fields? (mysql)
Groups: php.db 
Request: Send a blank email to php-db+get-22463@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? -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.

« previous php.db (#22463) next »