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

Help uploading .JPG
I have a problem with upload images when the ending is .JPG capitalized.. I really don't know what c

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

Can I use a loop
Hi buddies!

Once again with my doubts here.

Right now I am using this sql stat

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Material Issuing for receiving batch
Dear All experts in MM/ PP,

Material issuing from main stores to factory is currently usi

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

Is it possible to view php source code??
Hi All

I was just wondering if it's possible to view a websites php source code?
I know

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

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

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