[SOLVED] last 3 results, asc without 2 queries?

[Michdd]

Is there a way I can get the last 3 results of a query in ASC order without running more than one query? I know I can do this way:

 

$query = "SELECT * FROM `table` LIMIT " . (Query to count results) - 3 . ", 3";

But is there a better way?

[ldougherty]

Sorting it ASC is what makes your second query necessary.

 

If you wanted to select the last 3 results you could do DESC LIMIT 3

 

If you wante to do DESC LIMIT 3 you could then reverse the results array with array_reverse

http://us2.php.net/manual/en/function.array-reverse.php

[Michdd]

Oh, good idea thanks.