Hi

I'm creating a Magento-like sorting function on my product table (on back-end of my website).
Somehow I'm getting trouble to apply sort function (with where clause) only to the second 20 records of the table.
What it does is sort the whole table first then cut the result by limit clause.
What I need to do is get the 20 certain records from a table then sort it out.

Is there any other workaround for this one?

Thanks in advance.

Maybe it will be obvious to someone else without more information, but if I had the query, it'd be a bit easier.

Use an inner query...

select * 
from (
  select *
  from yourTable
  order by someField
)
limit 20

Edit:
The principle is valid, but I switched the conditions by error.
See this post: http://www.webmaster-talk.com/the-da...tml#post958637
to the correct one.

This will be executed from the inside toward the outside.
First, the inner query with the order by will be launched, and then, you will just pick the 20 first fields of that query with the outer part.

And... there came the "someone else"

What can I say...
DB is my trade.

And just to add:

If your DB server is MySql it will need to be ver 4.1 or above to support the subquery syntax.

Hum...
Proof-reading the OP post, I realize that I switched the conditions...

The query should be:

select *
from (
  select *
  from yourTable
  order by aField desc
  limit 20
)
order by someOtherField

yea, tripy, that one works. ^ ^
thanks alot. you're the guy!