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?

Your Answer:

Login to answer

Other forums

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s

Detail Expenses Report by Cost Center
I would like to obtain a report out of SAP that shows a list of expenses by cost center that shows t

animation progress while uploading files?
Hello, i have some website form to upload few files to server. i want to put some gif animation whi

Alterar a hora do servidor
Se alguém souber, ajude-me a adicionar 6 horas, obrigado
<tr>
&

Will this protect from mysql injection?
I do not want anything like DROP TABLE to work or any type of coding..

Heres my code.. is it

PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 200

Question about GD library
I am trying to make an image that shows a random quote from my database.


However I want t

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I