Hi all.

I'm trying to get results from a table BUT am running into an issue. Normally a query would run as follows;

.... ORDER BY blah blah LIMIT x, y

1. Order the results using ORDER BY
2. Limit the results starting from 'x' for 'y' results

My issue is that I want to do the two in reverse order;


.... LIMIT x, y ORDER BY blah blah

1. Limit the results starting from 'x' for 'y' results
2. Order the results using ORDER BY

Is there any way to do this? I know that simply restructuring the query doesn't work. Any help would be greatly appreciated

Thanks guys

what do you want achieve with this ?

Hi Falcone.

I have a page that allows paging of results (it currently shows customers their invoices). I also want to allow users to click on the table headings (e.g. invoice number, purchase order number, total etc.) to order that page's invoices accordingly.

The problem is that if I'm on page 2 which displays invoices 1005 -1009 and the user clicks on the heading to arrange them by total, it doesn't just sort the invoices on that page. It will order ALL of their invoices by total and return invoices from the 5th to 9th position.

Bit of a difficult one to explain, does that make sense?

Why would sorting the results on one page affect another? Before we go further, show us some of the code you are using.

As the other said, first be sure that it's really what you want.
The only practical use I had of this is when I wanted to randomize the last x results of a list.

To achieve this, you need to use a subquery to get the x records you want, and then you order them, like this:

select *
from (
  select x,y,z
  from tblSource
  order by z desc
  limit 10 offset 0
) as tbl1
order by tbl1.x asc