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

Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

Error querying database.
I get the above error when trying to insert some values to a datatable.
Here's the code :

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

PHP Session Issue
I'm having an issue with one section on my website dealing with sessions. Now I know that myself and

add 20 000 to the rowcnt
Hi ...
I need to add 20 000 to the row count but just cant find a way to do this i am new to php

Securing a user input - need some confirmation
Hello All,

I am in the process of recoding a large proportion of an e-commerce site, one of 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