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?

No comments posted yet

Your Answer:

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

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place. I have a main window with a ajax grid

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

serializing objects - loses methods - the point being?
Hi

I know that serializing an object will lose the methods. But whats the point in that? What

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

Open/Close Links in Php
Hello, Hoping someone can inform me how I can get PHP to automatically open a set of links in a new

xml
<?php

echo "<h1>XML Articles</h1>";

$home

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea

button help
i originally had this but realised it is much easier to have a button.

Code: <?php

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