[SOLVED] change sequence of some records in query result ?

[eluser]Zeeshan Rasool[/eluser]
[quote author="saidai jagan" date="1257786171"]can u pls explain this?
B cos i m eager to kno this. [/quote]
Off course ! it depends on your query i used it in joins i need to take the 7th number of record to top and 11th to 2nd position so for that i use after my where clause:

Code:

order by id=7 Desc, id=11 desc

Simple : you can use like this.

Cheers.