<?php require_once('Connections/dbcon.php'); ?>
<?php require_once('Connections/cohdb.php'); ?>
<?php require_once('Connections/dbcon.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];


mysql_select_db($database_dbcon, $dbcon);
$query_Recordset2 = "SELECT * FROM events ORDER BY ID DESC";
$Recordset2 = mysql_query($query_Recordset2, $dbcon) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

mysql_select_db($database_dbcon, $dbcon);
$query_Recordset3 = "SELECT * FROM events ORDER BY ID DESC";
$Recordset3 = mysql_query($query_Recordset3, $dbcon) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);

$maxRows_rsDesc = 3;
$pageNum_rsDesc = 0;
if (isset($_GET['pageNum_rsDesc'])) {
  $pageNum_rsDesc = $_GET['pageNum_rsDesc'];
}
$startRow_rsDesc = $pageNum_rsDesc * $maxRows_rsDesc;

mysql_select_db($database_dbcon, $dbcon);
$query_rsDesc = "SELECT * FROM events ORDER BY id DESC";
$query_limit_rsDesc = sprintf("%s LIMIT %d, %d", $query_rsDesc, $startRow_rsDesc, $maxRows_rsDesc);
$rsDesc = mysql_query($query_limit_rsDesc, $dbcon) or die(mysql_error());
$row_rsDesc = mysql_fetch_assoc($rsDesc);

if (isset($_GET['totalRows_rsDesc'])) {
  $totalRows_rsDesc = $_GET['totalRows_rsDesc'];
} else {
  $all_rsDesc = mysql_query($query_rsDesc);
  $totalRows_rsDesc = mysql_num_rows($all_rsDesc);
}
$totalPages_rsDesc = ceil($totalRows_rsDesc/$maxRows_rsDesc)-1;

mysql_select_db($database_cohdb, $cohdb);
$query_Recordset1 = "SELECT * FROM events ORDER BY id DESC";
$Recordset1 = mysql_query($query_Recordset1, $cohdb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Our Ministry Partners</title>
<style type="text/css">
<!--
body {
	background-image: url(images/home_pg_bg.jpg);
	background-repeat: no-repeat;
}
.li {
      color:#CCCCCC;
	  font-family:Tahoma;
	  font-size:14px;
	  text-decoration:none;
	  }
.li2 {
      color: #0099FF;
	  font-family:Tahoma;
	  font-size:12px;
	  text-decoration:none;
	  }
#apDiv1 {
	position:absolute;
	left:192px;
	top:98px;
	width:271px;
	height:242px;
	z-index:1;
}
#apDiv2 {
	position:absolute;
	left:481px;
	top:95px;
	width:343px;
	height:673px;
	z-index:2;
}
#apDiv3 {
	position:absolute;
	left:193px;
	top:428px;
	width:281px;
	height:286px;
	z-index:3;
}
#apDiv4 {
	position:absolute;
	left:193px;
	top:374px;
	width:283px;
	height:52px;
	z-index:4;
}
.style10 {
	font-size: 12px;
	font-family: Tahoma;
}
#apDiv5 {
	position:absolute;
	left:2px;
	top:766px;
	width:143px;
	height:28px;
	z-index:5;
}
.adminlink {color: #CCCCCC}
#apDiv5 a {
	text-decoration: none;
}
#apDiv5 a {
	font-size: 14px;
	color: #CCCCCC;
}
.style11 {
	color: #CCCCCC;
	font-family: Tahoma;
	font-size: 14px;
}
.btmlink {
	font-size: 9px;
	color: #666666;
	text-decoration: none;
}
-->
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script src="SpryAssets/SpryCollapsiblePanel.js" type="text/javascript"></script>
<script type="text/javascript">
function MM_CheckFlashVersion(reqVerStr,msg){
  with(navigator){
    var isIE  = (appVersion.indexOf("MSIE") != -1 && userAgent.indexOf("Opera") == -1);
    var isWin = (appVersion.toLowerCase().indexOf("win") != -1);
    if (!isIE || !isWin){  
      var flashVer = -1;
      if (plugins && plugins.length > 0){
        var desc = plugins["Shockwave Flash"] ? plugins["Shockwave Flash"].description : "";
        desc = plugins["Shockwave Flash 2.0"] ? plugins["Shockwave Flash 2.0"].description : desc;
        if (desc == "") flashVer = -1;
        else{
          var descArr = desc.split(" ");
          var tempArrMajor = descArr[2].split(".");
          var verMajor = tempArrMajor[0];
          var tempArrMinor = (descArr[3] != "") ? descArr[3].split("r") : descArr[4].split("r");
          var verMinor = (tempArrMinor[1] > 0) ? tempArrMinor[1] : 0;
          flashVer =  parseFloat(verMajor + "." + verMinor);
        }
      }
      // WebTV has Flash Player 4 or lower -- too low for video
      else if (userAgent.toLowerCase().indexOf("webtv") != -1) flashVer = 4.0;

      var verArr = reqVerStr.split(",");
      var reqVer = parseFloat(verArr[0] + "." + verArr[2]);
  
      if (flashVer < reqVer){
        if (confirm(msg))
          window.location = "http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash";
      }
    }
  } 
}
</script>
<link href="SpryAssets/SpryCollapsiblePanel.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style12 {font-family: Tahoma}
.style13 {font-size: 14px}
.style14 {font-size: 12px}
.style17 {font-family: Tahoma; font-weight: bold; }
.style18 {font-size: 10px}
#apDiv8 {
	position:absolute;
	width:200px;
	height:115px;
	z-index:6;
	left: 2px;
	top: 830px;
}
#apDiv6 {	position:absolute;
	width:138px;
	height:190px;
	z-index:7;
	left: 7px;
	top: 568px;
}
#apDiv9 {	position:absolute;
	width:151px;
	height:32px;
	z-index:9;
	left: 384px;
	top: 36px;
}
.style19 {
	color: #0066FF;
	font-weight: bold;
	font-size: 14px;
}
#apDiv7 {
	position:absolute;
	width:200px;
	height:48px;
	z-index:10;
	left: 622px;
	top: 28px;
}
#apDiv10 {
	position:absolute;
	width:273px;
	height:258px;
	z-index:11;
	left: 190px;
	top: 499px;
}
#apDiv11 {
	position:absolute;
	width:200px;
	height:115px;
	z-index:12;
	left: 365px;
	top: 396px;
}
.style21 {font-size: 12px; color: #2973CC; }
.style23 {font-size: 13px; color: #2973CC; }
-->
</style>
</head>

<body onload="MM_CheckFlashVersion('8,0,0,0','Content on this page requires a newer version of Adobe Flash Player. Do you want to download it now?');">
<div style="position:absolute; top:150px; width: 142px; height: 410px;">
  <p><a href="index.php" class="li">Home</a></p>
  <p><a href="mission.html" class="li">Our Mission</a></p>
  <p><a href="ds.html" class="li">Doctrinal Statement</a></p>
  <p class="style11"><a href="newsletter.html" class="li">Newsletter</a></p>
  <div id="CollapsiblePanel1" class="CollapsiblePanel">
    <div class="CollapsiblePanelTab style12 style13 adminlink" tabindex="0">Programs</div>
    <div class="CollapsiblePanelContent style12 adminlink style14 li"><br />
     &nbsp;<a href="children.html" class="li2">Groundbreakers</a><br />
    &nbsp;<a href="preteen.html" class="li2">Seeds of Hope</a><br />
    &nbsp;<a href="youth.html" class="li2">Disciples of Hope</a><br />
    &nbsp;<a href="dt.html" class="li2">Drama Team</a><br />
    &nbsp;<a href="pt.html" class="li2">Praise Team</a><br />
    &nbsp;<a href="co.html" class="li2">Community Outreach</a><br />
    &nbsp;<a href="se.html" class="li2">Special Events</a></div>
  </div>
  <p><a href="vision.html" class="li">Our Vision</a><br />
    <br />
    <a href="omp.html" class="li">Our Ministry Partners</a><br />
    <br />
  <a href="contact.php" class="li">Contact Us</a></p>
  <p>&nbsp;</p>
</div>

<div id="apDiv1">
  <p class="style10"><span class="style19">Dear Partners</span>,<br />
    <br />
    Children of Hope appreciates all support given for the mission God  has placed before us.  Many have given  one-time gifts and many are giving continually.   Thank you!   We pray God blesses you, your church, your ministry, and/or your  business as you sow into Children of Hope.</p>
  <p class="style10">Many of our individual partners do not want to receive any recognition.  So, we are only listing churches, ministries,  and businesses that continually give in some capacity.  This is so that you may visit them and learn  of more ministry opportunities.  </p>
  <p class="style10">If you are a continual partner of Children of Hope and your name  does not appear on this list and you would like it to appear, please send us an  email so that we may add it.</p>
  <p class="style10">Thanks,</p>
  <span class="style10">Everyone at Children of Hope</span>
  <p align="center" class="style17">&nbsp;</p>
</div>
<div id="apDiv2">
  <p align="center"><span class="style12"><span class="style23"><strong>Our Ministry Partners</strong><br />
        <strong>(Listed A-Z)</strong></span></span></p>
  <p class="style10"><strong><em>Below are <u>churches, ministries, and businesses</u> that partner with us on a continual basis.   They partner in a variety of ways which may include providing  financially and/or their services.   </em></strong></p>
  <p class="style10"><strong>Arbonne  International, Inc.</strong> <br />
    All natural... anti-aging skin care products for men and  women, nutrition, detox, weight loss, makeup and more.<br />
    Sue Clackum – Independent Consultant<br />
    20% of all sales placed from the website below are donated  to Children of Hope.  <br />
  <a href="http://www.sueclackum.myarbonne.com/">www.sueclackum.myarbonne.com</a>   Instructions:  (1) Click “Shop Online” (2) Place order. (3)  At check out in client information type your name/COH.  (Example:   Jane Doe / COH)  Typing COH after  your name ensures that the consultant knows you have been referred from the  Children of Hope website.</p>
  <p class="style10"><strong>Buffalo Trail   Baptist Church  </strong><br />
    <a href="http://www.buffalotrailbaptist.org/">www.buffalotrailbaptist.org</a></p>
  <p class="style10"><strong>Connection Fellowship</strong><br />
    <a href="http://www.theconnectionfellowship.org/">www.theconnectionfellowship.org</a></p>
  <p class="style10"><strong>American Missionary Alliance</strong><br />
    <a href="http:// www.amissionarya.org"> www.amissionarya.org</a></p>
<p class="style10"><strong>Harvest Outreach   Church</strong><br />
      <a href="http://www.harvest-outreach.com/">www.harvest-outreach.com</a><br />
    <br />
      <strong>Robertson Creek  Baptist Church</strong><br />
    144 Robertson Creek Road<br />
    Bulls Gap   TN 37711<br />
    423-235-3134<br />
    No Website</p>
  <p class="style10"><strong>Stepping Out Inc.</strong><br />
    <a href="http://www.stepoutinc.org/">www.stepoutinc.org</a></p>
  <p class="style10"><strong>Watkins Chapel United  Methodist Church</strong><span class="style10"><a href="http://www.gozaydin.com/">www.gozaydin.com</a> </span>  </p>
  <h3><br />
    </h3>
</div>
<div class="style10" id="apDiv5"><a href="admin_menu.php">Administration</a></div>
<div id="apDiv7"><a href="vo.html"><img src="images/volbtn.png" alt="Click here for volounteering opportunities" width="202" height="50" border="0" /></a></div>
<br>
<p></p>

<div id="apDiv8">
  <table width="966" border="0">
    <tr>
      <td><div align="center"><span class="style21"><a href="index.php" class="btmlink">HOME</a> |<a href="mission.html" class="btmlink"> OUR MISSION</a> |<a href="ds.html" class="btmlink"> DOCTRINAL STATEMENT</a> | <a href="newsletter.html" class="btmlink">NEWSLETTER</a> | <a href="children.html" class="btmlink">CHILDREN</a> |<a href="preteen.html" class="btmlink"> PRETEEN</a> | <a href="youth.html" class="btmlink">YOUTH</a> |<a href="dt.html" class="btmlink"> DRAMA TEAM</a> <a href="pt.html">|</a></span><span class="btmlink"><a href="pt.html" class="btmlink"> PRAISE TEAM</a> </span><span class="style21">| <a href="co.html" class="btmlink">COMMUNITY OUTREACH</a> | <a href="se.html" class="btmlink">SPECIAL EVENTS</a> |<a href="vision.html" class="btmlink"> VISION </a>|<a href="contact.php" class="btmlink"> CONTACT US</a></span></div></td>
    </tr>
    <tr>
      <td><p align="center" class="style21"><span class="style18">ALL RIGHTS RESERVED CHILDREN OF HOPE COPYRIGHT 2009<br />
        CREATED BY</span> <a href="http://www.rdjhome.com" class="btmlink">RDJ GRAPHICS</a> </p></td>
    </tr>
  </table>
</div>
<div id="apDiv6"><img src="images/handprints.png" width="132" height="180" /></div>
<div id="apDiv9"><img src="images/handprints1.png" width="147" height="28" /></div>
<div id="apDiv10"><img src="images/futuresite2.jpg" width="267" height="252" border="3" /></div>
<h2>&nbsp;</h2>

<div id="apDiv11"><img src="images/palm.png" width="91" height="91" /></div>
<script type="text/javascript">
<!--
var CollapsiblePanel1 = new Spry.Widget.CollapsiblePanel("CollapsiblePanel1", {contentIsOpen:false});
//-->
</script>
</body>
</html>
<?php
mysql_free_result($Recordset1);

mysql_free_result($Recordset2);

mysql_free_result($Recordset3);

mysql_free_result($rsDesc);
?>