Jake Johnson wrote:
No kidding. I didn't know that. Thanks a lot!
Regards, Jake Johnson [EMAIL PROTECTED]
______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts.
On Mon, 14 Jul 2003, Gabriel Guzman wrote:
On Mon, 2003-07-14 at 17:44, Jake Johnson wrote:
Be careful! Phil wanted the top 20 and the limit 20 will only return a
random 20 records.
Actually, LIMIT x will return the first x rows of a query, not random records. In fact, you can even combine ORDER BY and LIMIT if you want to get the first x rows of some order.
http://www.mysql.com/doc/en/SELECT.html http://www.mysql.com/doc/en/LIMIT_optimisation.html
gabe.
You can even specify an offset like this LIMIT 10, 20. This will skip the top 10 and give you the next 20. --
Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax & voicemail)