LIMIT & DESC question

[Anon]

Hi,

i want to provide a HTML-table, which contains the info as retrieved from a "select" query.
This query has a LIMIT set, but now i want to add the possibility for the user to sort the current limited table with "DESC".
However, if i simply add "DESC" to my select-query, the LIMIT starts from the end and not from the start of the table and so i get a different output.
Example:
row1 | row2 | row3
11 | 21 | 31
12 | 22 | 32
13 | 23 | 33

instead of getting:

row1 | row2 | row3
13 | 23 | 33
12 | 22 | 32
11 | 21 | 31

i get:

row1 | row2 | row3
17 | 27 | 37
18 | 28 | 38
19 | 29 | 39

hm, i hope i could express my problem well enough.
Well, so my question: is there an easy way to solve this problem?

Thanks for your help,

Regards,
Duncan

[[deleted]]

The LIMIT is done at the very end of the query, after the ORDER BY

You cannot re-order the results AFTER the LIMIT clause has been done.

you will have to order them manually in PHP, or insert the results into a temporary table and order them there.

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.yapf.net/

[Anon]

Ah, ok...
thanks for the reply.

I just thought it may be able with MySQL itself.
...so, in order to get my wanted result, i simply use the same query and do a array_reverse() 🙂