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

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

Stopped working!
So I had to change some stuff, none of it major. Stuff like the extension_dir and such. BEFORE I did

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u

phpMailer not working ..........
HI,
I was playing with the phpMailer script and tried to send a smiple mail using their test scri

How to add advertisment on top of videos
Hello,
I was told that i should find the answer for this problem in this forums.
I searched a

PHP5 - AJAX help
I've been following the tutorial on w2schools (http://www.w3schools.com/php/php_ajax_database.asp) a

PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some