- • datum narození a úmrtí (pokud je k dispozici) je vyjádřeno slovně
• datum narození a úmrtí (pokud je k dispozici) je vyjádřeno číselně
A nyní SQL kódy pro oba reporty:
Data slovy:
SELECT FLOOR(DATEDIFF(deathdatetr, birthdatetr)/365.25) as Age_at_Death,birthdate,deathdate,CONCAT('<a href="getperson.php?personID=',personid,'&tree=', gedcom,'">', lastname,', ', firstname, '</a>') as Name FROM tng_people WHERE living = 0 AND birthdatetr !=0 and deathdatetr !=0 ORDER BY Age_at_Death DESC, deathdate, birthdate, lastname ASC
Data číslem:
SELECT FLOOR(DATEDIFF(deathdatetr, birthdatetr)/365.25) as Age_at_Death, deathdatetr AS Death,birthdatetr AS Birth,CONCAT('<a href="getperson.php?personID=',personid,'&tree=', gedcom,'">', lastname,', ', firstname, '</a>') as Name FROM tng_people WHERE living = 0 AND YEAR( birthdatetr ) !=0 and YEAR (deathdatetr) !=0 ORDER BY Age_at_Death DESC, Death, Birth, lastname ASC
Good luck!