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

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

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