Birthday Calendar

[jasendorf]

I'd like to create a birthday list for the living... in other words, an ordered list of birthdays for those alive.

I've already written the custom SQL for it (it works and runs fine in phpmyadmin), but it only displays the row numbers when I run it (in other words, it's useless).

SELECT tng_people.living, lnprefix, suffix, tng_people.branch, birthdate, DAYOFYEAR( birthdatetr ) AS birthday, firstname, lastname, tng_people.personID, tng_people.gedcom, nameorder

FROM tng_people

WHERE tng_people.living =1

AND birthdatetr != '0000-00-00'

AND tng_people.gedcom = "TREE-all"

ORDER BY birthday

Any suggestion on what I need to do to get TNG to display the fields from the return?

[jasendorf]

Actually, I've found a way to go about this without using SQL... I guess my affintity for writing SQL led me to try and do it that way before actually looking at my options.

Pretty simple:

Select Display options

Criteria: living=yes

Sort Fields: month only from birth date true, day only from birthdate true

That did it.