ChurchInfo

I've used this query to gather all the wedding dates. Then I have to match husband and wife together by family ID and date before I display it. That may be a way in SQL to combine spouses, but I haven't figured that out. Maybe this will help you along.

$sql = "SELECT family_fam.fam_ID as 'FamID', family_fam.fam_Name AS 'Family', family_fam.fam_WeddingDate AS 'Anniversary', person_per.per_FirstName as 'Head', person_per.per_fmr_ID as 'Place'
FROM family_fam
LEFT JOIN person_per
ON family_fam.fam_ID=person_per.per_fam_ID
WHERE (person_per.per_fmr_ID=1
OR person_per.per_fmr_id=2)
AND family_fam.fam_WeddingDate > '0000-00-00'
ORDER BY family_fam.fam_ID";