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

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

Calling variables
I want to call this to my website but it doesn't display what I want it to,

Code: <h5&

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

Please Help my PHP Dating Function.
Hi everyone!

Well here is my code that displays this:

It works wonderful.

PHP Code To Change Font Color in Table Cell
I would appreciate help with the following snippet of my php code. I am just trying to change the f

How to Create a Dynamic table
col1 col2 date1 date2 date3 date4..........
a b v1 v2 v3 v4

Undefined variable when using $_SERVER['PHP_SELF']
Hi guyz, please suggest me something...
On first.php I have one input field NAME, and on posting

how make 2 column in table with data tybe long row
hi every one

I want make in my table 2 column with data tybe long raw

how thi

PHP If Else statement for breadcrumb
Hi

I am trying to use a PHP if else statement to display a breadcrumb link on wordpress

PHP mail() returns true but doesn't work
First off I apologize if this is a newbie question, and I generally don't like asking questions that