A list of tutorials by David Varner.
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