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

How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?

Let's say I have:

Setting/Modify Headers using mail() function
I have a question about setting email headers when using mail() in a php script.

When I send

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

dinamic "textboxes"?
Ey all, my first post here, i hope its not a hard one

I display mysql results in a table

rename the file
File.txt

Code: ***DOCUMENT***
..DN:
000044255
..CB:
..SN:
..PY:
2009
..E

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Help with Hyperlink
Hi,

What I am trying to do may be simple, I just can't get it to work. Ok...

I am usin

Multiple PHP errors when clicking a link..and..removing a ghost..
Hi - I have 2 problems with a new website - homeswapvacations.com, which I need help solving.