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

Extract specific information from a PHP Multidimensional Array
Howdy! I've racked my brain over this for 24 hours now. I think it's time I asked for help. I'm lear

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

Code Help.. If txt input box empty search X instead..
I am having a problem with my search script. At current it will simply search by a selected date whi

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

Problem with coding MySQL query
I'm having heaps of trouble getting one of my PHP/MySQL queries to work for some reason (and the fun

jquery validation in codeIgniter
hai i need to add client side validation to my fiels which are selected in a forloop.the fields are

delete comma
HI,

How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

using a loop help
Hi guys , i need some help. I have this loop :
while ($row = mysql_fetch_assoc($Result)) { ?&

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