[insert_php] include “archdiocese/directory2/web_common.inc”;

$OrganisationID = $_GET[“Ox45Q”];

$strSocial = “”;
$stmt = $d_conex->prepare(“SELECT Name, TransportGuide, Address, Postcode, Picture, ParishSec, Telephone, District, Population, Founded, Fax, Website, Wiki, Comments, Email, FeastDate, Facebook, Twitter, Flickr, GooglePlus, HistoryURL, GoogleMapURL, BookShopContactName, BookshopEmail, BookshopContact, ColumbariaContactName, ColumbariaEmail, ColumbariaContact, KinderContactName, KiderEmail, KinderContact, MedicalCentreContactName, MedicalCentreEmail, MedicalCentreContact, WakeChapelContactName, WakeChapelEmail, WakeChapelContact, StudentCareContactName, StudentCareEmail, StudentCareContact, Type, ChildCareContactName, ChildCareEmail, ChildCareContact FROM Dir_Organisation where OrganisationID = ?”);
$stmt->bind_param(“s”,$OrganisationID);
$stmt->execute();
$stmt->store_result();
$numrows = $stmt->num_rows;
$stmt->bind_result($RS_Name, $RS_TransportGuide, $RS_Address, $RS_Postcode, $RS_Picture, $RS_ParishSec, $RS_Telephone, $RS_District, $RS_Population, $RS_Founded, $RS_Fax, $RS_Website, $RS_Wiki, $RS_Comments, $RS_Email, $RS_FeastDate, $RS_Facebook, $RS_Twitter, $RS_Flickr, $RS_GooglePlus, $RS_HistoryURL, $RS_GoogleMapURL, $RS_BookShopContactName, $RS_BookshopEmail, $RS_BookshopContact, $RS_ColumbariaContactName, $RS_ColumbariaEmail, $RS_ColumbariaContact, $RS_KinderContactName, $RS_KiderEmail, $RS_KinderContact, $RS_MedicalCentreContactName, $RS_MedicalCentreEmail, $RS_MedicalCentreContact, $RS_WakeChapelContactName, $RS_WakeChapelEmail, $RS_WakeChapelContact, $RS_StudentCareContactName, $RS_StudentCareEmail, $RS_StudentCareContact, $RS_Type, $RS_ChildCareContactName, $RS_ChildCareEmail, $RS_ChildCareContact);
while($stmt->fetch())
{
//Convert Feast Date for Display
$arrayFeastDate = explode(“-“, $RS_FeastDate);
$RS_FeastDateYear = (int)$arrayFeastDate[0];
$RS_FeastDateMonth = lookupMonth($arrayFeastDate[1]);
$RS_FeastDayDate = $arrayFeastDate[2];
$strFeastDate = $RS_FeastDayDate . ” ” . $RS_FeastDateMonth;
$RS_Address = str_replace(“””,”‘”,$RS_Address);
}
echo ”

“; [/insert_php][insert_php] //START: To display physical services for this parish
$phyType = “”;
$TitleLabel = “”;$stmt = $d_conex->prepare(“SELECT Type, PhysicalServicesTitle, Day, OpenTime, CloseTime, OtherInformation FROM Dir_OrganisationPhysicalServices WHERE OrganisationID = ? and Active=’Y’ order by Type ASC, PhysicalServicesTitle ASC”);
$stmt->bind_param(“s”,$OrganisationID);
$stmt->execute();
$stmt->store_result();
$num_rowsPhy = $stmt->num_rows;
$stmt->bind_result($Physical_Type, $Physical_PhysicalServicesTitle, $Physical_Day, $Physical_OpenTime, $Physical_CloseTime, $Physical_OtherInformation);if ($num_rowsPhy>0){
echo “”;
}
while($stmt->fetch()){if ($phyType != $Physical_Type){
echo “”;
$phyType = $Physical_Type;if ($Physical_Type==”Childcare Centre”){
echo “”;
}if ($Physical_Type==”Columbarium”){
if ($RS_ColumbariaContactName!=””){
if ($RS_ColumbariaEmail!=””){
echo “”;
} else {
echo “”;
}
}
}if ($Physical_Type==”Kindergarten”){
if ($RS_KinderContactName!=””){
if ($RS_KiderEmail!=””){
echo “”;
} else {
echo “”;
}
}
}if ($Physical_Type==”Student Care” && $RS_StudentCareContactName!=””){
if ($RS_StudentCareEmail!=””){
echo “”;
} else {
echo “”;
}
}if ($Physical_Type==”Wake Chapel”){
if ($RS_WakeChapelContactName!=””){
if ($RS_WakeChapelEmail!=””){
echo “”;
} else {
echo “”;
}
}
}if ($Physical_Type==”Medical”){
if ($RS_MedicalCentreContactName!=””){
if ($RS_MedicalCentreEmail!=””){
echo “”;
} else {
echo “”;
}
}
}if ($Physical_Type==”Media / Bookshop”){
if ($RS_BookShopContactName!=””){
if ($RS_BookshopEmail!=””){
echo “”;
} else {
echo “”;
}
}
}
}if ($TitleLabel!=$Physical_PhysicalServicesTitle){
if ($Physical_OpenTime!=””&&$Physical_CloseTime!=””){
echo “”;
$TitleLabel=$Physical_PhysicalServicesTitle;
} else {
echo “”;
$TitleLabel=$Physical_PhysicalServicesTitle;
}
} else {
if ($Physical_OpenTime!=””&&$Physical_CloseTime!=””){
echo “”;
} else {
echo “”;
}
}}if ($num_rowsPhy>0){
echo “”;
echo “”;
}
//END: To display physical services for this parish[/insert_php]