.

Première solution:

$current = mysql_fetch_assoc($requete);
if ($current) {
while($next = mysql_fetch_assoc($requete))
{
echo 'nom:'.$current['nom'].'
position:'.$current['position'].'
id;'.$current['id'].' ';
echo 'prochain:'$next['nom'].' '.$next['position']."\n";
$current = &$next;
}
}

Deuxième solution: utiliser mysql_data_seek