At 12:22 -0800 3/30/02, destr0 wrote: >----- Original Message ----- >From: "Tyler Longren" <[EMAIL PROTECTED]> >To: "destr0" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Saturday, March 30, 2002 9:38 AM >Subject: Re: LIMIT, ORDER Dilema > > >> You have to have the LIMIT clause after the ORDER clause. > >If this is the case than can someone give me an example of a select query >that would select records 30 - 45 of a table >and then order those selected records by certian fields. becuase if I have >the "order by" clause first, that throws the result set I'm looking for out >of order.
Does that even make sense? "records 30 - 45" has no meaning, given that the server is free to return records in any order it pleases. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
