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

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

Any decent php formatter/beautifier/pretty printer?
Any decent php formatter/beautifier/pretty printer class/function?

I found the following whil

how to get sn motherboard
Hello.
I want to get serial number motherboard, cpu and else hardware.
Can You show me sam

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

Problem related to Creation of PDF File?
Hi All,
I am facing a problem related to creation pdf file. when I am creating a pdf file of do

Good Programming and Web Design Books
Hi,

I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it