Say you want to select the most recent 10 records (ORDER BY date DESC, LIMIT 10), but display them in ascending order… Just put the select as a temporary table in a subquery, and select from that result set with the order you want them returned:

SELECT * FROM (										
	SELECT * FROM table
	ORDER BY date DESC
	LIMIT 10) AS t
ORDER BY date ASC