if ($row["address1"] != "") { print "<tr>"; print "<td style='width: 33%; padding-top: 15px; vertical-align: top' colspan=4>"; print "<span style='font-size: 115%; font-weight: bold'>" . _('Address 1') . "</span><br/>"; $address1 = addressFormat($row["address1"], $row["address1District"], $row["address1Country"]); if ($address1 != FALSE) { print $address1; } print "</td>"; print "</tr>"; } if ($row["address2"] != "") { print "<tr>"; print "<td style='width: 33%; padding-top: 15px; vertical-align: top' colspan=3>"; print "<span style='font-size: 115%; font-weight: bold'>" . _('Address 2') . "</span><br/>"; $address2 = addressFormat($row["address2"], $row["address2District"], $row["address2Country"]); if ($address2 != FALSE) { print $address2; } print "</td>"; print "</tr>"; } print "</table>"; print "<h4>"; print _("School Information"); print "</h4>"; print "<table class='smallIntBorder' cellspacing='0' style='width: 100%'>"; print "<tr>"; print "<td style='width: 33%; padding-top: 15px; vertical-align: top'>"; print "<span style='font-size: 115%; font-weight: bold'>" . _('Last School') . "</span><br/>"; print $row["lastSchool"];
$sqlFamily = "SELECT gibbonFamily.gibbonFamilyID, nameAddress, homeAddress, homeAddressDistrict, homeAddressCountry FROM gibbonFamily JOIN gibbonFamilyChild ON (gibbonFamilyChild.gibbonFamilyID=gibbonFamily.gibbonFamilyID) WHERE gibbonPersonID=:gibbonPersonID"; $resultFamily = $connection2->prepare($sqlFamily); $resultFamily->execute($dataFamily); } catch (PDOException $e) { print "<div class='error'>" . $e->getMessage() . "</div>"; } while ($rowFamily = $resultFamily->fetch()) { if ($rowFamily["nameAddress"] != "") { print $rowFamily["nameAddress"] . ", "; } if (substr(rtrim($rowFamily["homeAddress"]), -1) == ",") { $address = substr(rtrim($rowFamily["homeAddress"]), 0, -1); } else { $address = rtrim($rowFamily["homeAddress"]); } $address = addressFormat($address, rtrim($rowFamily["homeAddressDistrict"]), rtrim($rowFamily["homeAddressCountry"])); if ($address != FALSE) { $address = explode(",", $address); for ($i = 0; $i < count($address); $i++) { print $address[$i]; if ($i < count($address) - 1) { print ", "; } } } } print "</td>"; print "<td>"; $contact = ""; try { $dataFamily = array("gibbonPersonID" => $row["gibbonPersonID"]);