Help with SQL Ordering in PHP

[rach01]

hello

 

I have a query which is long, but the main section I have a question about is

 

GROUP BY id ORDER BY id DESC LIMIT  10

 

this works ok and gives me the first 10 records in descending order, so it gets oldest to newest

 

what do I need to do, to keep the query (first 10 records) but order by newest to oldest

 

can anyone help me, I've searched high and low, and tried lots of ideas, but cannot get it to work right

 

thanxs

[rach01]

does anyone know the answer?

[cpd]

Firstly, why are you grouping by ID when ID is, or at least should be, unique?

 

I'm not really convinced you've searched high and low as you've identified the ORDER BY is ordering your result set but haven't searched how to use it? The key word is DESC meaning descending. You'll want to change it to ASC meaning ascending.

 

Moreover, be patient for an answer. This forum has people contributing from all over the world with different time zones so just wait 24 hours and you should have an answer!

Edited July 4, 2013 by cpd

[Barand]

use a subquery eg

SELECT invoiceId 
FROM
    (
    SELECT invoiceId FROM invoices
    ORDER BY invoiceID DESC
    LIMIT 10
    ) as lastten
ORDER BY invoiceId ASC;

[rach01]

thanks, your advice help