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

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

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

Filename and Line Number Custom Error
I have a class, with a method that accepts 2 parameters. I would like to output error messages.

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

Help with writing "$" with fopen
I just can't get my syntax correct. Could someone help me please? I am trying to write a connect fil

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