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

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Required to login help
I'm trying to set up my site so users have to be logged into the forum to access the site.I've been

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct

Post PHP form to non-existing page
The company that I work for host their PHP code on IIS on a Windows server, no Apache, so no mod_rew

Any decent php formatter/beautifier/pretty printer?
Any decent php formatter/beautifier/pretty printer class/function?

I found the following whil

Weird Problem with curl while sending data
I am facing a weird problem with sending data to a site via curl.

If i send the value by this

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

Multi-image upload problems
Lets see if I can get some help on this one. Can anyone show me what I am doing wrong here. I'm just