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)...

I've tried LIMIT 49,50 but it still re-order the first 50 records...

anyone has a clue?

Your Answer:

Login to answer

Other forums

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

Help with translating C code into assembler code
Hi im doing a project that moves a robot around a maze avoiding walls and need some help with conver

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

ASP.NET 2.0 - Enter Key - Default Submit Button
Hi,One of the most annoying things in developing web pages is handling the "Enter key" for form subm

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba