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)...

Did you know?Explore Trending and Topic pages for more stories like this.
I've tried LIMIT 49,50 but it still re-order the first 50 records...

anyone has a clue?
No comments posted yet

Your Answer:

Login to answer
116 Like 8 Dislike
Previous forums Next forums
Other forums

problem in pagination when processing with selectbox form
Hi,

I have a search form, with select boxes, if am selecting the value from the form, it work

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc

Unidentified index error in a simple form
I have been trying to make an HTML form that is handled by a PHP script. So far my attempts to get i

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

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

Upload, SSL and more php help
I recently just installed a ssl cert and do i use https for the whole site or just for the checkout.

The control with ID 'ace' requires a ScriptManager on the page
I'm trying to add a simple AlwaysVisibleControlExtender to my page, but it's not working. I get the

Typing math
I've added support for typesetting math using LaTeX on the forums.

Example:
Code: [Select]

Disabling SAP menu
How do I disable SAP menu for all the users and just restrict them to User Menu in SAP ECC 6.0?

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash