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

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?

I have

the problem with str_replace
$str="hahahahahahahahahahahahahaha";
$nn=1;
$str=str_replace('ha','MyGod',$str,$nn);

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

foreach loop, assistance request
I would like some guidance on the usage of foreach as I try to parse through a large database and wh

MVC - Code review
I'm in the process of trying to wrap my head around MVC, and as part of that, I'm attempting to impl

A little help needed passing hidden values to next page
I have a page that has hidden values in a form.

example
Code: <input name='signupID

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