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

Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the

Last Weeks sDate and eDate.
sDate - Start Date
eDate - End Date

I need to pull two dates for "Last Week" whi

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h

File upload issues
Hi Guys,

Can anyone see any issues with this code:
Code: $setImage= 'productimages/' . dat

Windows Authentication
I have a website which is windows authenticated.
now i want something more on this application.<

single page with referrer to show correct page
I have a simple website with a couple of different pages. I would like to be able to in a div tag w

Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']