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

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes

post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit bu

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br

FROM_UNIXTIME($phpdate);
Hello,

I tried to use this :

$date = FROM_UNIXTIME($phpdate);

ANd I was t

Session is not saving
I am not trying to do anything too fancy, I am just trying to get some $_SESSION data to save and us

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones