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)...

Did you know?Explore Trending and Topic pages for more stories like this.
I've tried LIMIT 49,50 but it still re-order the first 50 records...

anyone has a clue?
No comments posted yet

Your Answer:

Login to answer
116 Like 8 Dislike
Previous forums Next forums
Other forums

php forms and database navigatio
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f

Convert Binary String to Decimal
Trying to Get:
Decimal: 305419896

Out of:
Binary String: xV4

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

Am i doing this wrong?
Im pulling from an Oracle database some info... one of which is a field count_pnums which is a NUMBE

Strange Oracle Query problem
Ok So I have this PHP class that talks to a Javascript class that basically creates a table of infor

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set

Need help with simple code, back and forward buttons.
Basically, I have a set of pages in a folder, which have the title somephrasehere_09.php, somephrase

login to other site by sending post variables
hey,

here is my problem: my school gave me a mail account for school-stuff use. they mail us

How to file_get_contents when login required?
Hello!

I am trying to read data from a page that you have to be logged into to view, I am try

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash