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

Simple PHP/Java Help..
Hi,
I'm trying to build a little program to do with calculating postage. Unfortunately i haven't

Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou

how to insert value
I am having file bookissueadd.php..... in which i am having tag

<td height="21&q

PHP & Images [Resize, Crop, Save]
Hey! Well I have a little dilema, hoping I could find some guidance.

I have a CMS and on the

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

mysqli_fetch_assoc returns multiple arrays, how to return a single array
Hello, I am using mysqli_fetch_assoc which is returning multiple rows, so it looks like:

Code

session checking in page load
hai all I have a web site is www.Mryas.com in this my login page is Page1.aspx its co

Request for tunning the below query
Hi,

Can any one help me on the below query while improving the performance,