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

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

MySQL-PHP Query Results Help
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I

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

In the loop (for th

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

Need help to modify php ELSE code
I'm trying to find a way to have the php code display a message if there is no inventory listed in t

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we

Values disappear from my array :( HELP!
hey all, I have a lil mysql/php/apache script that queries a database
and pulls put 5 integers.

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

Sum of Values in an Array
This is probably really simple... but it's been years since I've written anything, so bare with me!<

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