php-db | 2002122

Re: [PHP-DB] Checking if number is in bottom three? From: Leif K-Brooks (eurleif <email protected>)
Date: 12/23/02

Thanks, but what I want to do is check if a number is in the first 3,
not return the first three. If returning the first three and seeing if
any of them matches is the only way, I'll do that, but it doesn't seem
that great for the server.

SELPH,JASON (HP-Richardson,ex1) wrote:

>select myfield from table order by myfield DESC limit 3
>
>That will return the last 3 records in your database where the highest
>number is the last. Think of it as sorting by that number in reverse and
>only returning the first 3.
>
>Cheers
>Jason
>
>-----Original Message-----
>From: Leif K-Brooks [mailto:eurleif <email protected>]
>Sent: Monday, December 23, 2002 10:14 AM
>To: php-db <email protected>
>Subject: [PHP-DB] Checking if number is in bottom three?
>
>
>I need a way to check if a number is in the bottom three of a column in
>my database. For example, if I had a list of number in my table like this:
>1
>5
>8
>12
>60
>10000
>10001
>I might need to know if 5 was in the bottom three, which it would be.
> But if I checked 60, it wouldn't be. I could check the lowest number
>and add 3 to it, but it may have gaps. 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