TROUVER LES PROCHAINS ANNIVERSAIRES

// la requete - pour l'exemple on recupére les 5 prochains anniversaires
$sql = "SELECT nom,
	prenom,
	DATE_FORMAT(`anniv`,'%d/%m/%Y') as anniv,
	YEAR(CURDATE()) - YEAR(anniv) as age,
	mod(DATE_FORMAT(`anniv`,'%m%d') - DATE_FORMAT(CURDATE(),'%m%d'), 1231 ) + IF( mod(DATE_FORMAT(`anniv`,'%m%d') - DATE_FORMAT(CURDATE(),'%m%d'), 1231 ) >0, -1, 2000 ) as poids
FROM `contacts` 
WHERE YEAR(`anniv`)<>'0000'
ORDER BY poids ASC
LIMIT 5";

$req = mysql_query($sql) or die(mysql_error());

while ($res = mysql_fetch_array($req))
{
  echo $res['anniv'].' '.$res['nom'].' '.$res['prenom'].' ('.$res['age'].' ans).<br />';
}