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

Wrong Info sent Using $get in form
Hi i have this code that i tried to make to send some info from one page to aother with lots of ppls

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

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

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

Alternate messaging
I have 4 strings in MySQL db1

$string1 : Hello
$string2 : Hi
$string3 : Great
$strin

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

PHP Search Issue
Hi, I am using the following code to search and return flights from a database. The user searches by

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

cURL Sending File as Post
This is a bit complicated, I'm just hoping someone else has run into this and knows how to do it a d