LIMIT and ORDER BY

Apparently, MySQL with limit and order by will do LIMIT then ORDER BY

Is there a way i can get it to return the first say 10 rows after its ordered? Like it doing it the other way round?

Cheers 🙂

select * from table order id desc or asc limit 0, 10 or limit 10

This is my code:
$one=1;
$fetch=10;

SELECT ID, Name, Url, Image, Enter, Leave, Description FROM $table ORDER BY Enter DESC limit $one, $fetch

I entered the 11th entry to have an Enter of 3000, the highest.

It is not shown in the results

This is still doing Limit THEN ORDER rather than Order then limit

you don't have the enter column on the mysql table, try this

select * from $table order by ID limit $one, $fetch

My problem:

Setting the first int as one, it missed the first entry - must be 0

Is there a way MySQL can number them on their place in the ordering?

Such as the 5th will be given: $number=5?

Or similar?

Otherwise i need PHP code 🙁

Originally posted by DoD
My problem:

Setting the first int as one, it missed the first entry - must be 0

replace the value of one put it like this

$one = 0;