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

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

If a record matches an existing record do nothing
So I don't know if I should put this here or in mysql, but what my script is for is for people to ad

Echo multiple lines of html code
Hi guys,

I would like to know if there is a way to echo multiple lines of html codes.

validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners

serializing objects - loses methods - the point being?
Hi

I know that serializing an object will lose the methods. But whats the point in that? What

Hyperlink is adding an extra gap to variable
Hi, here's my problem..

I have a php generated page with a hyperlink which opens in a new win

How to make a input/output field with multiple lines
Hello.
I put a input/output field on the screen but I could not change height of it. I need to

Selecting an "empty" date formated field
How do you select an "empty" date field? I've tried the few ways I can think.
SQL> select

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const