1 2 3 4 5
| $sql = "SELECT a.Nom AS Nom,a.Prenom AS Prenom,b.Ville AS Ville,b.HorsZone AS HorsZone,a.DateNaissance As DateNaissance,
DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(a.DateNaissance, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(a.DateNaissance, '00-%m-%d')) AS Age,
IF((DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(a.DateNaissance, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(a.DateNaissance,'00-%m-%d')))>=60,true,false) as Plus60
FROM TAdministres AS a LEFT JOIN TBatiments as b ON (b.IdProprietaire=a.IdAdm)
GROUP BY a.Nom,a.Prenom;"; |
Partager