Church Profile

.RptTabAm {width: 1700px;}.RowTabAm{padding-bottom: 1px;}.ColA{float: left; text-align: left; width: 50%;}.ColB{float: right; width: 50%; text-align: left;}.clearAm{clear: both;}

“;

if($resAmm = mysqli_query($con, $qAmm)) {
$col = ‘1’;
echo ‘

‘;
while ($rowAmm = mysqli_fetch_array($resAmm)) {
// if ($nCount < 3) { if ($col == '1') { echo '
‘; }
else {
echo ‘

‘; }
echo “

“.$rowAmm[‘Ammenity’].”

“;
if ($col == ‘1’) {
echo ‘

‘;
$col = ‘2’;
}
else {
echo ‘

‘;
$col = ‘1’;
}

}
}
echo ‘

‘;
//_free_result($res);
mysqli_close($con);
}
function DisplayDoves($nDoves)
{
switch ($nDoves)
{
case 1:
$str = ‘‘;
$str .= ‘‘;
$str .= ‘‘;
$str .= ‘‘;
echo $str;
break;
case 2:
$str = ‘‘;
$str .= ‘‘;
$str .= ‘‘;
$str .= ‘‘;
echo $str;
break;
case 3:
$str = ‘‘;
$str .= ‘‘;
$str .= ‘‘;
$str .= ‘‘;
echo $str;
break;
case 4:
$str = ‘‘;
$str .= ‘‘;
$str .= ‘‘;
$str .= ‘‘;
echo $str;
break;
}
}

function DisplaySeal($Metal)
{
switch ($Metal)
{
case ‘Platinum’:
echo ‘plat‘;
break;
case ‘Gold’:
echo ‘‘;
break;
case ‘Silver’:
echo ‘‘;
break;
case ‘Bronze’:
echo ‘‘;
break;
}
} $BldDoves = 0;
$ProgDoves = 0;
$SupportDoves = 0;
$SpiritDoves = 0;

$qSQL = ” SELECT RDate, bio, Cert, Activities, Pastor, Website, Email, Phone, Zip, State, City, PhyAddr, MailingAddr, Updates, ChurchName, CertYear “;
$qSQL .= ” FROM Church WHERE ID = “.$Church_id;
$con = STCertDBConnect();
if($res = mysqli_query($con, $qSQL)) {
if($success = mysqli_num_rows($res) > 0) {
while ($row = mysqli_fetch_array($res)) {
$bio = $row[‘bio’];
$act = $row[‘Activities’];
$cdate = $row[‘RDate’];
$cert = $row[‘Cert’];
$certyear = $row[‘CertYear’];
$pastor = $row[‘Pastor’];
$website = $row[‘Website’];
$email = $row[‘Email’];
$phone = $row[‘Phone’];
$zip = $row[‘Zip’];
$pa = $row[‘PhyAddr’];
$maddr = $row[‘MailingdAddr’];
$upds = $row[‘Updates’];
$city = $row[‘City’];
$st = $row[‘State’];
$church = $row[‘ChurchName’];
}
}
}
mysqli_free_result($res);

$qSQL = ” SELECT DovePts FROM Bld2 WHERE ChurchID = “.$Church_id.” AND CertYr = “.chr(39).$certyear.chr(39);
if($res = mysqli_query($con, $qSQL)) {
if($success = mysqli_num_rows($res) > 0) {
while ($bldrow = mysqli_fetch_array($res)) {
$BldDoves = $bldrow[‘DovePts’];
}
}
}
mysqli_free_result($res);

$qSQL = ” SELECT DovePts FROM Progm WHERE ChurchID = “.$Church_id.” AND CertYr = “.chr(39).$certyear.chr(39);
if($res = mysqli_query($con, $qSQL)) {
if($success = mysqli_num_rows($res) > 0) {
while ($progrow = mysqli_fetch_array($res)) {
$ProgDoves = $progrow[‘DovePts’];
}
}
}
mysqli_free_result($res);

$qSQL = ” SELECT DovePts FROM Supprt WHERE ChurchID = “.$Church_id.” AND CertYr = “.chr(39).$certyear.chr(39);
if($res = mysqli_query($con, $qSQL)) {
if($success = mysqli_num_rows($res) > 0) {
while ($Supportrow = mysqli_fetch_array($res)) {
$SupportDoves = $Supportrow[‘DovePts’];
}
}
}
mysqli_free_result($res);

$qSQL = ” SELECT DovePts FROM Spirit2 WHERE ChurchID = “.$Church_id.” AND CertYr = “.chr(39).$certyear.chr(39);
if($res = mysqli_query($con, $qSQL)) {
if($success = mysqli_num_rows($res) > 0) {
while ($Spiritrow = mysqli_fetch_array($res)) {
$SpiritDoves = $Spiritrow[‘DovePts’];
}
}
}
mysqli_free_result($res);
mysqli_close($con);
$Loc = $pa.’,+’.$city.’,+’.$st.’+’.$zip ;
$Loc = str_replace(” “, “+”, $Loc);
$Maplink = “https://www.google.com/maps/place/”.$Loc;
$websitelink = $website;
if(strtoupper(substr($website, 1, 4)) <> ‘HTTP’) {
$websitelink = ‘http://’.$website; }
?>

‘; }
if ($Church_id == 173) {echo ‘‘; }
if ($Church_id == 197) {echo ‘‘; }
if ($Church_id == 204) {echo ‘‘; }
if ($Church_id == 194) {echo ‘‘; }
if ($Church_id == 57) {echo ‘‘; }
if ($Church_id == 160) {echo ‘‘; }
if ($Church_id == 164) {echo ‘‘; }
if ($Church_id == 129) {echo ‘‘; }
if ($Church_id == 148) {echo ‘‘; }
if ($Church_id == 178) {echo ‘‘; }
if ($Church_id == 176) {echo ‘‘; }
if ($Church_id == 165) {echo ‘‘; }
if ($Church_id == 162) {echo ‘‘; }
if ($Church_id == 131) {echo ‘‘; }
if ($Church_id == 78) {echo ‘‘; }
if ($Church_id == 62) {echo ‘‘; }
if ($Church_id == 221) {echo ‘‘; }
if ($Church_id == 49) {echo ‘‘; } ?>


(Phy Address)
,
Map‘;
echo $str; ?>

(Phone)
“.$email.”“; echo $str; ?> (Email)
‘.$website.’‘;
echo $str; ?> (Website)
(Pastor)


Dove Rating by Category

Building:
Program:
Support:
Spirit of Accomm:

Bio:


Announcements & Regular Activities:


Amenities:

Date Certified:

Changes/Updates since last Certification: