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

session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.

include problem
I have my root folder as:
Code: $root = $_SERVER["SITE_HTMLROOT"]; // the server root<

Filtering for a phrase using pregmatch
Here is my code which looks for addresses which start with ' src=" '

Code: [Select]preg_

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

New to PHP and just trying to understand a little code.
I hope I'm not annoying anyone or breaking the rules but I was wondering about this bit of code righ

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

how to read and write into a word document using php...?
hi,
I need,reading and writting into a word document using php.




Thank u inadva

check how many commas the variable containing the query has between [i]select[/i
Hi...

iv made an sql table that contains id number - name of sql query and an sql query.
T

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi