<?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>Ways to Help</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:173px;
	top:294px;
	width:320px;
	height:197px;
	z-index:3;
}
#apDiv2 {
	position:absolute;
	left:520px;
	top:446px;
	width:399px;
	height:220px;
	z-index:4;
}
#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:6;
}
.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:7;
	left: 2px;
	top: 858px;
}
#apDiv6 {
	position:absolute;
	width:138px;
	height:190px;
	z-index:8;
	left: 7px;
	top: 568px;
}
#apDiv9 {	position:absolute;
	width:151px;
	height:32px;
	z-index:9;
	left: 384px;
	top: 36px;
}
#apDiv7 {
	position:absolute;
	width:200px;
	height:48px;
	z-index:10;
	left: 615px;
	top: 25px;
}
#apDiv10 {
	position:absolute;
	width:399px;
	height:119px;
	z-index:11;
	left: 518px;
	top: 90px;
}
#apDiv11 {
	position:absolute;
	width:399px;
	height:318px;
	z-index:12;
	left: 518px;
	top: 199px;
}
#apDiv12 {
	position:absolute;
	width:141px;
	height:117px;
	z-index:13;
	left: 616px;
	top: 620px;
}
#apDiv13 {
	position:absolute;
	width:343px;
	height:214px;
	z-index:14;
	left: 173px;
	top: 480px;
}
.style21 {color: #0033FF}
.style22 {
	font-size: 14px;
	color: #333333;
}
.style23 {font-size: 14}
.style24 {color: #0033FF; font-weight: bold; font-size: 14px; }
.style25 {color: #663300}
.style26 {
	color: #000000;
	font-weight: bold;
}
#apDiv14 {
	position:absolute;
	width:319px;
	height:196px;
	z-index:16;
	left: 173px;
	top: 95px;
}
#apDiv15 {
	position:absolute;
	width:138px;
	height:34px;
	z-index:5;
	left: 637px;
	top: 674px;
}
.style27 {color: #FF0000}
#apDiv16 {
	position:absolute;
	width:290px;
	height:115px;
	z-index:1;
	left: 521px;
	top: 611px;
}
.style28 {color: #A6824A}
-->
</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; z-index: 2;">
  <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 style21 style23"><span class="style26">Do you feel God leading  you to help Children of Hope?<br />
</span><br />
    <strong>If so, here are three  ways you can:</strong><br />
    <strong><br />
    <span class="style28">(1) We need prayer  partners.  </span></strong><span class="style28"><br />
    <strong>(2) We need funding for  the ministry.</strong><br />
    <strong>(3) We need volunteers  to work in the ministry.</strong></span></p>
  <p class="style10">&nbsp;</p>
  <p align="center" class="style17">&nbsp;</p>
</div>
<div id="apDiv2">
  <p align="left"><span class="style10"><span class="style24">Volunteers</span><br />
  If you would like to become a volunteer to work in this ministry,  simply fill out a <a href="va.pdf">Volunteer Application</a>.   Mail it to the post office box listed in the feedback section.  We will contact you to set up an interview.  Before filling out the application be sure  you have read our mission and doctrinal statement.  One other thing to consider, Children of Hope  does background checks on all volunteers.   At the time of interview, you will be asked to provide some personal  information (date of birth, copy of driver’s license, social security number,  etc.).  Please DO NOT mail this  information.<span class="style21"><br />
   </span></span>      </p>
  <p align="left">&nbsp;</p>
  <h3><br />
    </h3>
</div>
<div class="style10" id="apDiv5"><a href="admin_menu.php">Administration</a></div>
<div id="apDiv10">
  <p><span class="style10"><span class="style24">Prayer Partners</span><br />
    If you would like to become a prayer partner of Children of  Hope simply send us an e-mail. In the feedback section, give us your e-mail  address.  Then, type in the Subject  “Prayer Partner” and in the Comment section, give us your name and  address.  We will then add you to a group  e-mail that goes out as prayer needs arise in the ministry.</span></p>
</div>
<div id="apDiv14"><img src="images/handnhand.png" width="311" height="189" border="0" /></div>
<br>
<div id="apDiv11">
  <p><span class="style10"><span class="style24">Financial Partners</span><br />
    If you would like to become a financial partner of Children  of Hope simple send us an e-mail.  In the  feedback section, give us your e-mail address.   Then, type in the Subject “Financial Partner” and in the Comment section,  give us your name and address.  We will  add you to our bi-monthly newsletter mailing list.  You will receive up-to-date news about  Children of Hope and a self-addressed envelope to send donations at your  convenience.  Or for quicker results, you  may send donations to: </span></p>
  <p><span class="style10">P.O. Box 14021   <br />
    Morristown TN 37814.<br />  
    <br />
    CHILDREN OF HOPE IS A 501-C-3 <br />
    NON PROFIT ORGANIZATION. <br />
    <strong><br />
    ALL DONATIONS ARE TAX DEDUCTABLE.</strong></span>   </p>
</div>
<div id="apDiv13">
  <p><span class="style12"><span class="style22"><strong><u>Volunteer Positions include:  </u></strong><br />
        <strong><em><u>Some of these positions may already  be filled.</u></em></strong><br />
        <strong><em><u>On the Volunteer Application please  indicate which position you are interested in.</u></em></strong></span></span></p>
  <p class="style25 style10"><strong>• Large group teacher (4 yrs  &amp; Kindergarten)<br />
  • Large group assistants (4yrs  &amp; Kindergarten)<br />
    • Large group teacher (grades 1st  – 3rd)<br />
    • Small group leaders (grades 1st  – 3rd)</strong><strong><br />
    • Large group teacher (grades 4th  – 12th)<br />
    • Small group leaders (grades 4th  – 12th)</strong> <br />
    <strong>• Large group teacher (grades 4th  – 12th <br />
    </strong><strong>&nbsp;&nbsp;&nbsp;Discipleship class)<br />
    • Small group leaders (grades 4th  – 12th<br /> 
    &nbsp;&nbsp;&nbsp;Discipleship class)</strong><strong><br />
    • Sound and technology<br />
    • Food Coordinator <br />
    • Food assistants<br />
    • Bus drivers<br />
    • Bus assistants<br />
    • Accountability Coordinator<br />
    • Accountability assistants<br />
    • Secretarial Assistant<br />
    • Janitorial dutie</strong>s</p>
</div>
<div id="apDiv15">
  <div align="center"><a href="http://get.adobe.com/reader/thankyou/activex/?installer=Reader_8.1.3_English_for_Windows&amp;addon=Google_Toolbar_6.1&amp;g=d"><span class="style10 style18 style27">This pdf requires Adobe Reader 6.X</span><br />
  <img src="images/adobereader.png" width="91" height="21" border="0" /></a></div>
</div>
<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="apDiv12"> <a href="va2.pdf"><img src="images/vabtn.png" width="177" height="35" border="0" /> <br />
  </a>
  <div align="center"></div>
</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);
?>