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

Storing the referrer in session... problems with tabs
Hello All

I am currently working on an ERP project based on the MVC methodology, when a user

Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problem

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

Transaction variant for VA02 not working
My requirement is to have transaction for user to only add the output and print a sales order.

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

connect() succeeds but accept() does not?
Please help me with this problem. I'm working on a time-sensitive project where I'm using TCP socket

PHP Include not working
The website is http://www.grlistingservices.com

The code block is as follows:

<

Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other

Need help in log in and log out?
hi there all of u. i have recently created a site for someone. i have placed log in and log out and

Form help: Syntax & Logic
Hello again all,

I'm working on a form and ran into a wall (again) and can't seem to think th