omoutop - 7:09 am on Apr 26, 2013 (gmt 0)
Your basic query should be modified like this:
$query = "SELECT .... FROM tableName WHERE .... ORDER BY fieldName DESC LIMIT 10"
ORDER BY [fieldName] DESC will sort your result in a descending order (latest to oldest)
LIMIT 10 will restrict your result set to 10 records