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

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

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Does deleting the spmlog directory critical?
Hi Everyone,

Please, hope you could help me. We're having problems with the SAP backup. I

How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.
Plz tell me how to assign

Why is this function returning a false value when it shouldn't be??
This is in an include file. I want it to check a value in an html form and see if it's just white s

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

How to Handle more than one submit button in single form?
Hi
I have one PHP file which contains one Form. In this form there are two Submit type Buttons

Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.

I need to create a drop

Ball movement
I want to move a ball from one point to another and it should hit a group of balls at the other end