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

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

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

disabling a button server-side then re-enabling client-side breaks button postback
I have a tabbed container and a button (not in the container) on a page. If the first tab is selecte

Writing Windows Device Drivers with C
Yes: one of the nice features of C is void*. You can put anything there and get anything out. Very

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

Snapshot from video
anyone knw how to make a snapshot maker from avi n mkv format.
for example if i give a direct lin

Cron Job and Output
I have php codes running under a cron job.
But everytime i output (echo) , it comes out as comple

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
OK, I think but have a problem, only 1 pro

PHP Code To Change Font Color in Table Cell
I would appreciate help with the following snippet of my php code. I am just trying to change the f