Limits and order bys

I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my users to be able to pageanate through result sets, so I've written some code that will display the results of a query 15 rows at a time in a HTML table. The next set of results can be accessed by

Re: Limits and order bys

Sort them yourself after retrieving them. Rob wrote: I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my users to be able to pageanate through result sets, so I've written some code that will display the results of a query 15 rows at a time in a

RE: Limits and order bys

: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:36 PM To: Rob Cc: [EMAIL PROTECTED] Subject: Re: Limits and order bys Sort them yourself after retrieving them. Rob wrote: I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my

RE: Limits and order bys

11:36 PM To: Rob Cc: [EMAIL PROTECTED] Subject: Re: Limits and order bys Sort them yourself after retrieving them. Rob wrote: I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my users to be able to pageanate through result sets, so I've