codice:SELECT campo FROM tabella ORDER BY id DESC LIMIT 0, 9Codice PHP:
//tralascio connessione al db
$sql = "SELECT campo FROM tabella ORDER BY id DESC LIMIT 0, 9";
$query = mysql_query($sql);
while ($row=mysql_fetch_array($query)){
print $row['campo']."
";
}