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

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

How to grab certain words ??
I am working with this API

Returns JSON.
curl http://letsbetrends.com/api/current_trends

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

pop3 and fsockopen
So I am able to connect to the pop3 server, log in, and check how many messages there are. I am hav

Help with writing "$" with fopen
I just can't get my syntax correct. Could someone help me please? I am trying to write a connect fil

elseif help!
OK so I'm new to the site, as well as PHP altogether (Trying my hand at managing an online RPG) and

Big Problem!! Please help
Hi Guys,

Im making a website for a friend have encountered a really annoying problem. When ev