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

Struct/union and scope problem!
HI all , I have
Code: in header.h typedef struct Node Link; /* ---------

LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a

PHP FTP Can't upload Big FIles
Anyone had any success using FTP to upload a file say 90m?

im using ftp_put and it returns fa

CHMOD script
Hi,

I need a script to read all files in a folder and set to 777.

Can anyone help out

parse error
Parse error: syntax error, unexpected '[', expecting ')' in /Users/admin/Sites/phptest/array.php on

How to pass parameter to tag query?
Hi,
I want to get the value of a tag at a specific time (like 10/27/09 15:29:59), I need to giv

Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the

Disable Scrollbar in TableControl
Hello everbody,

please can anybody help me - outherwise i'm going to become desperate :P<

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s