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

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

Change log of Cost centre change in Plant maintenance order
Hi,
How to view Change log of Cost centre in Plant maintenance order. Not visible thru 'Docume

PHP and SMS
Hi all forum members. I am new here and am unsure what category shoild I post this in.
Moderator

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

restricting another login once you logout
Hello,

how can I restrict a page from login authenticating against info in a MySQL DB for a s

[Need Help] php timing issues
I don't know what is going wrong. I need some help with being able to set an image at 9:00am Colorad

PHP using IF to display error
i have a MySQL query and i want to display 1 thing only if the number of affected rows is >=1

pls clear my confusion
Hi friends,

Pls solve my query .

what is the exact use of Scope Resolution Operator( i

Place specific image in html page when specific name is typed.
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r