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)...

Did you know?Explore Trending and Topic pages for more stories like this.
I've tried LIMIT 49,50 but it still re-order the first 50 records...

anyone has a clue?
No comments posted yet

Your Answer:

Login to answer
116 Like 8 Dislike
Previous forums Next forums
Other forums

Issues: PHP Forms -Clearing
I've tried looking online before actually asking for help, but I've been looking for about the past

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

Count Session and Trigger Events
I am New in PHP, seeking a method to count logged users by counting the sessions or any …, is

help with contest script
I would like to code a contest script to my site but i don't know how. Could someone just give me pu

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

Good Programming and Web Design Books
Hi,

I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo

php require help needed
Ok i tried to use the search funtion but the word require is everywhere.

i'm really new to cr

listcube issue
Hi
I have a virtual cube ZREMOTE. I use Tcode "listcube" to retrieve contents. I use of the

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash