The general task is following:
There is table ‘books’ where entries about books are saved. There is page ‘library’ where the list of books is shown in e-frame.
I need to:
a) search on an attribute
b) make paginal/complete output
c) change over from paginal to complete output
d) sorting on the output within library attributes

Everything is done. But a logical error appeared (I haven’t faced anything like this before): I make paginal output with limit by request i.e. request, for example, for the third page looks like this:
SQL

SELECT * FROM `books ` WHERE...(search condition) LIMIT 8, 3

It doesn’t matter until we start dealing with sorting:

SQL

SELECT * FROM `books ` WHERE...(search condition) ORDER BY `author ` DESC LIMIT 8, 3

By such a request changing of sorting on a page also changes its contains i.e. firstly a complete request through all the base is done and then limit is extracted from it.  The question is: what should I do?