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

disabling a button server-side then re-enabling client-side breaks button postback
I have a tabbed container and a button (not in the container) on a page. If the first tab is selecte

Email Processor
I have a few questions so this post will be a larger one! Sorry, but I'm a bit of a PHP newbie so be

Material Master Update through BAPI - Follow up material not updated
Hi Experts,

I am updating the material master through a custom transaction using the BAPI

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

a function to check directory depth
I'm working on a php script to upload files in to a set directory.
the user can select to upload

Multiple while loops
I have several DB queries that I know should be returning results and aren't. I have a feeling it ha

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul

Remove directories not empty
hi,
i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.<

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on