- // 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 />';
- }
// 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 />';
}