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

help with database debug pls
Parse error: syntax error, unexpected T_ELSE in /home/content/m/e/s/mesick/html/students/05/php/chec

Cursor statement failed with errors
Following statement failed with the errors.

cursor proj_cursor1 is (select projectID from

How to change Time Zone
HI
I want to change the time zone of the server to another country.How can do that?

Thanks

Legal Issues for SAP ERP o ERP in general
Hi experts,

Can someone please help me finding some documentation about legal issues tha

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi