Getting valie between two fields? (mysql)
| From: | Leif K-Brooks | 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.