RE: [PHP-DB] Getting valie between two fields? (mysql)
| From: | USA) | Date: | Wed, 16 Oct 2002 17:21:07 +0000 |
| Subject: | RE: [PHP-DB] Getting valie between two fields? (mysql) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22466@lists.php.net to get a copy of this message | ||
Ooopss.... 2 answers is better than none. :-) ...
James, can I have a free database too? Just kidding... it's cool you offered.
<>< Ryan
-----Original Message-----
From: Ryan Jameson (USA)
Sent: Wednesday, October 16, 2002 11:19 AM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] 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:eurleif@buyer-brokerage.com]
Sent: Wednesday, October 16, 2002 11:08 AM
To: php-db@lists.php.net
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?
--
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php