connect_error) die($conn->connect_error); $query =<<<_END SELECT distinct LENGTH(TRIM(FM.IND_ID)) sort1, SUBSTRING(FM.IND_ID,LOCATE('.', FM.IND_ID)+1 ) sort2 , FM.FAM_ID,FM.IND_ID ,FM.GIVEN, FM.MARRIED , FM.BORN , FM.DIED , FM.PHOTO , FM.OBIT , FM.DECEASED , FM.MALE, FAM.SURNAME FROM fam_member FM, family FAM where FM.fam_id=FAM.fam_id AND (FM.fam_id= $famid OR FM.ind_id = PARENTID( $famid ) ) ORDER BY 1,2 ; _END; $result = $conn->query($query); if (!$result) die($conn->error); $rows = $result->num_rows; $spousecnt = 0; $spouseid = ''; for ($j = 0; $j < $rows; ++$j) { $result->data_seek($j); $row = $result->fetch_array(MYSQLI_ASSOC); $famnames[] = $row['given']; $fampics[] = $row['photo']; $fambdays[] = $row['born'] ; $famrip[] = $row['died'] ; $famobit[] = $row['obit']; $famage[] = age( $row['born'],$row['died'] ; $famids[] = $row['ind_id'] ; $famfamids[] = $row['fam_id'] ; $mnames[] = $row['married'] ; $wedates[] = $row['wed_date'] ; $man[] = $row['male']; $lastname[] = $row['surname'] ; $deaths[] = $row['deceased']; $portraits[] = $row['surname'] . '_' . $row['fam_id']; } echo <<<_END _END; ?>