How to separate records and ORDER BY


Posted on 16th Feb 2014 07:03 pm by admin

Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and use ORDER BY to re-order whether DESC or ASC

How can i do the ORDER BY without re-order first 50 records (0-49)...

Did you know?Explore Trending and Topic pages for more stories like this.
I've tried LIMIT 49,50 but it still re-order the first 50 records...

anyone has a clue?
No comments posted yet

Your Answer:

Login to answer
116 Like 8 Dislike
Previous forums Next forums
Other forums

Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl

Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Estimations and Effort
HI Gurus,

Would like to know whether SAP have a provision for carrying out the Project es

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

curl javascript problem
Hi Experts.
I'm new curl and wanna to get some info from this http://www.amadeus.net/

when

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash