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

Echo multiple lines of html code
Hi guys,

I would like to know if there is a way to echo multiple lines of html codes.

How to insert random unique values in 2 columns ?
I have table with 2 columns

Create Table code_for_code (
first_code varchar2(10) uni

Hyperlink is adding an extra gap to variable
Hi, here's my problem..

I have a php generated page with a hyperlink which opens in a new win

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

Displaying image from database
Hi,

I've got a site where that's got a database behind it. Currently it has loads of items in

Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.
I post it here because ther

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

Running External Scripts
I am very new to PHP and am not even sure what I'm asking is possible. I have just installed mediaW

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?