Re: [PHP-DB] Checking if number is in bottom three?

[Leif K-Brooks]

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:[EMAIL PROTECTED]]
Sent: Monday, December 23, 2002 10:14 AM
To: [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