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

ldap connection
We are using ldap to get user information from the domain controller. It was working before. Recentl

Sequencing or queuing parallel process
Scenario is as follows
There is one parent process say P1 and 4 child processes say A B C D

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

PHP and MySQL on intranet?
Is it possible to use both these on an intranet network?

using explode() to fill in checkboxes
Hi

I have a field stored in a table that contains regions in the UK separated by commas. Ther

Data storage spaces in varchar2
Trying to understand what's happening.
I am selecting a value from a table that is defined as c

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

Redistributing dependent dlls
Hai all ,

I have created an application in VC++ using VS2008 in a development machine which r

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send