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

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Coding Critique
I was hoping someone could take a second and look down my code and see if they see any problems with

Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.

However

Problem with shopcart code
Hello, I am having a bit of trouble being able to add a product to my shopcart. My mysql database i

More pug propaganda.
http://www.youtube.com/watch?v=8Kkrmubsgf8

The commercial is definitely worth watching pug aw

Check premium expire
Hi,

I am making a simple file hosting site and want to check if users premium subscriptions h

Add User script "Could not execute query"
This should be an easy script but I can't get it to run. Can someone please help me?

<

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

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