Order By

[SNA]

Is there a way to 'ORDER BY' AFTER the LIMIT.

If I order by $var then LIMIT IT its basically sorting BEFORE what was selected in the limit.

if their are 1000 records and I order the data before I limit it is different then if I were to Limit it then order it.

Make sence?


SELECT * FROM $var ORDER BY $var2 LIMIT 0,40;


this erros out...

SELECT * FROM $var LIMIT 0,40 ORDER BY $var2;

Hints please.