Syphic.com

A list of tutorials by David Varner.

Get last X results in ASC or ABC order - Advanced

This is a query which grabs the last x number of results and then sorts them in ABC or ASC order.

$last2show = 10;
SELECT * FROM table WHERE id > (SELECT max(id) FROM table) - {$last2show} ORDER BY name ASC