Est-ce que ce code marcherait ? Le voilà :
$requete = mysql_query("SELECT * FROM matable ORDER BY date");
$num = 1;
$count = mysql_query("SELECT COUNT * FROM matable");
while($row = mysql_fetch_row($requete))
{
if($num >= ($count - 5))
{
...
}
$num++;
}