SELECT last X amount of rows?

[EchoFool]

Hey,

 

I have a query which orders by in ASC and limits 20, but this is the reverse of what i need as i need the "last 20" rows (the most up to date) but still in ASC order.... currently ORDER ASC LIMIT 20 gets 0 to 20.

 

How can i get the last 20 rows of a result in a query?

[premiso]

You need it in ASC order? Well you can always store the end results in an array and rsort the array:

 

SELECT * FROM table ORDER BY field DESC LIMIT 10

 

Should get you what you want, you will just have to manipulate the data when PHP has it.

[EchoFool]

So like:

 

<?php
//query
$row = mysql_fetch_assoc($Query);
//sort $row to ASC order  some how

For each  {
// stuff 
} 

?>

 

? Like that?

[kickstart]

Hi

 

Or

 

SELECT *
FROM (SELECT * FROM table ORDER BY field DESC LIMIT 20) a
ORDER BY field

 

All the best

 

Keith