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?

No comments posted yet

Your Answer:

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

How to know if online site made with PHP
Hello,
I see some sites that does not display extensions at all , for example:

www.site.co

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

Streaming local file from PHP while it’s been written to by a CURL process
I am creating a simple Proxy server for my website. Why I am not using mod_proxy and mod_cache is a

Probably a simple error...
I'm getting the error -- Parse error: syntax error, unexpected '{' in /home/content/c/s/t/csteffen24

Need help making a blockquote and line items conditional
I have some code I bought a few years ago that allows my clients to update content on their site usi

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

extract a file from zip file
hi,
i know how to unzip a zip file in php, but is there a way to just extract a certain file only

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

Wordpress IE issue
So I am trying to add the background shadow to my wordpress page. It works fine in Firefox but does

How do I create a 2D game "camera" to follow player?
In J2ME programming I'm targeting MIDP 2.0 devices.

I'm using gamecanvas and I was thinking t

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