<?php require_once('../../Connections/database.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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 = "") 
{
  if (PHP_VERSION < 6) {
    $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;
}
}
 
session_start();
$_SESSION['$mess']="";

require_once('../../Connections/database.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
  }
  
  
  	$_SESSION['$mess']="";
	#test values here

	if (empty($_POST['first_name'])) {

		$_SESSION['$mess']="First name ";
	
	}else{

	
	}
	
	if (empty($_POST['lastname'])) {

		$_SESSION['$mess']="First name ";
	
	}else{

	
	}

/*
	if (empty($_POST['lastname'])) {

		$mess=$mess." lastname";
	
	}else{


	}	

	if (empty($mess)) {

	
	}else{
	
		$mess=$mess." cannot be empty!";

	}
*/

  
  return $theValue;
}


$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO membership (`first`, `first name`, `last name`, email, telephone, address, city, postal, `time`, `interest area`, prov) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first'], "int"),
                       GetSQLValueString($_POST['first_name'], "text"),
                       GetSQLValueString($_POST['last_name'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['telephone'], "text"),
                       GetSQLValueString($_POST['address'], "text"),
                       GetSQLValueString($_POST['city'], "text"),
                       GetSQLValueString($_POST['postal'], "text"),
                       GetSQLValueString($_POST['time'], "date"),
                       GetSQLValueString($_POST['interest_area'], "text"),
                       GetSQLValueString($_POST['prov'], "text"));

  mysql_select_db($database_database, $database);
  $Result1 = mysql_query($insertSQL, $database) or die(mysql_error());
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO membership (`first`, `last name`, `first name`, email, telephone, address, city, postal, `time`, `interest area`, prov) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first'], "int"),
                       GetSQLValueString($_POST['last_name'], "text"),
                       GetSQLValueString($_POST['first_name'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['telephone'], "text"),
                       GetSQLValueString($_POST['address'], "text"),
                       GetSQLValueString($_POST['city'], "text"),
                       GetSQLValueString($_POST['postal'], "text"),
                       GetSQLValueString($_POST['time'], "date"),
                       GetSQLValueString($_POST['interest_area'], "text"),
                       GetSQLValueString($_POST['prov'], "text"));

  mysql_select_db($database_database, $database);
  $Result1 = mysql_query($insertSQL, $database) or die(mysql_error());
}


if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO membership (`first`, `first name`, `last name`, email, telephone, address, city, prov, postal, `time`, `interest area`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first'], "int"),
                       GetSQLValueString($_POST['first_name'], "text"),
                       GetSQLValueString($_POST['last_name'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['telephone'], "text"),
                       GetSQLValueString($_POST['address'], "text"),
                       GetSQLValueString($_POST['city'], "text"),
                       GetSQLValueString($_POST['prov'], "text"),
                       GetSQLValueString($_POST['postal'], "text"),
                       GetSQLValueString($_POST['time'], "date"),
                       GetSQLValueString($_POST['interest_area'], "text"));

  mysql_select_db($database_database, $database);
  $Result1 = mysql_query($insertSQL, $database) ;
  if (empty($Result1)) {
  	  
	$_SESSION['$themess']="";
	
  }else{
   	header ('Location: http://www.cnhhe-rcshe.ca/html/membership/thanks.html');
	exit ();
	}

}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Welcome  to the Canadian Network for Human Health and the 
Environment</title><META NAME="description" CONTENT="Welcome to the Canadian Network for Human Health and the Environment">
<META NAME="keywords" CONTENT="We are a Canadian-based network of non-governmental, research, health professional and policy organizations focusing on human health and the impacts of environmental exposures.">
		<meta name="Keywords" content="Canadian-based network of non-governmental, research, health professional and policy organizations, focusing on human health and the impacts of environmental exposures.">
<META NAME="language_of_resource" CONTENT="eng">
<META NAME="language_of_metadata" CONTENT="eng">
<META NAME="originator" CONTENT="Welcome to the Canadian Network for Human Health and the 
Environment ">
<META NAME="author" CONTENT="Barry Lindsay">
<META NAME="last_modified" CONTENT="Welcome to the Canadian Network for Human Health and the 
Environment ">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

//-->
</script>
<style>

.t { font-family:Geneva, Arial, Helvetica, san-serif;}
 A:link {font-family:Geneva, Arial, Helvetica, san-serif; color: #000000}
 A:visited {font-family:Geneva, Arial, Helvetica, san-serif; color: #000000}
 A:active {font-family:Geneva, Arial, Helvetica, san-serif; color: #000000}
 A:hover {font-family:Geneva, Arial, Helvetica, san-serif; color: #FE750C}
body,td,th {
	color: #FFFFFF;
}
body {
	background-image: url(file:///H|/graphics/backright-1.jpg);
}
.style93 {color: #000000}
.style98 {font-size: 14px; color: #000000; font-weight: bold; }
.style102 {color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 14px; }
.style103 {color: #000000; font-size: 14px; }
#main div {
	color: #000;
}
</style>
</head>

<script language="JavaScript" src="file:///H|/nblungsite/httpsdocs/_shared/rollovers.js" type="text/javascript"></script>
	<link rel="stylesheet" href="../../lungassociation2.css" type="text/css" />

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('file:///H|/graphics/linkbar/newlinkbar_r3_c2_f3.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c2_f2.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c4_f3.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c4_f2.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c6_f3.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c6_f2.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c8_f3.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c8_f2.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c12_f3.gif','file:///H|/graphics/linkbar/newlinkbar_r3_c12_f2.gif')"><table width="901" border="0" align="center" cellpadding="0" cellspacing="0" background="../../graphics/backnew.jpg">
  <!--DWLayoutTable-->
  <tr> 
    <td width="901" height="729" valign="top"> 
      <table width="703" height="686" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
        <!--DWLayoutTable-->
        <tr> 
          <td width="1" height="185"></td>
          <td colspan="7" valign="top"><div align="center"><a href="../../index.php"><img src="../../graphics/top.jpg" alt="Top" name="top" width="900" height="143" border="0" usemap="#topMap"></a><a href="../../index.php">
            <map name="topMap">
              <area shape="rect" coords="821,4,881,27" href="../../francais/html/membership_fr/index.php">
              <area shape="rect" coords="20,7,362,130" href="../../index.htm">
            </map>
          </a><a href="../index.htm"></a>
          <div id="PLHFO0Div" style="width:100%;height:32px;position:relative;">
<div style="width:100%;height:30px;border:solid 1px #000000;background-color:#394da4;text-align:left;">
           <ul style="margin:0;padding:0px;width:896px;height:30px;font-family:Geneva,Arial,Helvetica,sans-serif;font-size:11px;">
            <li class="PLHFOLink" style="display:block;float:left;width:128px;height:30px;text-align:center;background-color:#394da4;"><a href="../../index.html" style="display:block;padding:9px 6px 0px 6px;text-decoration:none;color:#ffffff;">Home</a></li>
            <li class="PLHFOLink" style="display:block;float:left;width:128px;height:30px;margin-left:0px;text-align:center;background-color:#394da4;"><a href="../News/index.html" style="display:block;padding:9px 6px 0px 6px;text-decoration:none;color:#ffffff;">News</a></li>
         <li class="PLHFOLink" style="display:block;float:left;width:128px;height:30px;margin-left:0px;text-align:center;background-color:#394da4;"><a href="../about/index.html" style="display:block;padding:9px 6px 0px 6px;text-decoration:none;color:#ffffff;">About&nbsp;Us</a></li><li class="PLHFOLink" style="display:block;float:left;width:128px;height:30px;margin-left:0px;text-align:center;background-color:#394da4;"><a href="../bulletin/index.html" style="display:block;padding:9px 6px 0px 6px;text-decoration:none;color:#ffffff;">Bulletin</a></li><li class="PLHFOLink" style="display:block;float:left;width:128px;height:30px;margin-left:0px;text-align:center;background-color:#394da4;"><a href="../delegateselection/index.html" style="display:block;padding:9px 6px 0px 6px;text-decoration:none;color:#ffffff;">Delegate&nbsp;Selection</a></li><li class="PLHFOLink" style="display:block;float:left;width:128px;height:30px;margin-left:0px;text-align:center;background-color:#394da4;"><a href="../webseminars/index.html" style="display:block;padding:9px 6px 0px 6px;text-decoration:none;color:#ffffff;">Web&nbsp;Seminars</a></li><li class="PLHFOLink" style="display:block;float:left;width:128px;height:30px;margin-left:0px;text-align:center;background-color:#394da4;"><a href="../contactus/index.html" style="display:block;padding:9px 6px 0px 6px;text-decoration:none;color:#ffffff;">Contact&nbsp;Us</a></li></ul></div><script type="text/javascript">var PLHFO_ID="PLHFO0"</script>
           <script type="text/javascript" src="../../Pluginlab/Scripts/linkbar/Copy of Copy of PLHFO.js">/* PLHFOMenu script ID:PLHFO0 */</script>
</div>
          </div></td>
        </tr>
        <tr>
          <td height="2"></td>
          <td width="4"></td>
          <td width="190"></td>
          <td width="9"></td>
          <td width="500"></td>
          <td width="10"></td>
          <td width="178"></td>
          <td width="9"></td>
        </tr>
        
        
        <tr>
          <td height="257"></td>
          <td>&nbsp;</td>
          <td valign="top"><div align="center"><img name="side" src="../../graphics/side.jpg" width="180" height="320" border="0" usemap="#m_side" alt="">
              <map name="m_side">
                <area shape="rect" coords="8,250,154,272" href="../links/diversepop.html" alt="" >
                <area shape="rect" coords="4,284,160,316" href="../links/multiplechemical.html" alt="" >
                <area shape="rect" coords="7,29,79,48" href="../links/air.html" alt="" >
                <area shape="rect" coords="8,59,64,80" href="../links/water.html" alt="" >
                <area shape="rect" coords="8,89,45,112" href="../links/soil.html" alt="" >
                <area shape="rect" coords="8,124,71,142" href="../links/food.html" alt="" >
                <area shape="rect" coords="7,155,133,175" href="../links/pesticides.html" alt="" >
                <area shape="rect" coords="7,185,165,206" href="../links/consumerproducts.html" alt="" >
                <area shape="rect" coords="7,214,153,239" href="../links/climatechange.html" alt="" >
              </map>
          </div></td>
          <td>&nbsp;</td>
          <td rowspan="4" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
            <!--DWLayoutTable-->
            <tr>
              <td width="500" height="16" valign="top" background="../../graphics/singelbar.jpg"><span class="style98">Membership</span></td>
           </tr>
            <tr>
              <td height="44" valign="top" background="../../graphics/back_membership.jpg" id="main">
                <p>&nbsp;</p>
                <div align="center"><strong>Contact: </strong><a href="mailto:louise.steeves@nb.lung.ca">louise.steeves@nb.lung.ca</a></div>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p>
                <p>&nbsp;</p></td>
           </tr>
            <tr>
              <td height="2"></td>
           </tr>
            
          </table>
            <p>&nbsp;</p>
          <p>&nbsp;</p></td>
          <td>&nbsp;</td>
          <td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
            <!--DWLayoutTable-->
            <tr>
              <td width="179" height="310" valign="top" background="../../graphics/whatsnew2.jpg" bgcolor="#ECE9D8"><p>&nbsp;</p>
                <ul><!-- #BeginLibraryItem "/Library/Untitled2.lbi" -->
<style type="text/css">
<!--
.style3 {font-size: 11px}
.style103 {font-size: 11px}
.style107 {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
}
.style105 {font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; }
-->
</style>

<p><span class="style107"><a href="../../pdf/Bulletin 20-May 10-E.pdf" class="style103"></a></span><a href="../../pdf/Bulletin 24-September 10 E (2).pdf" class="style103">Bulletin # 24 -Sept 2010</a><a href="../../pdf/Bulletin 23-August 10 E (2).pdf" class="style103"><br>
  Bulletin # 23 -Aug 2010</a><br>
  <span class="style107"><a href="../../pdf/Bulletin 22-July 10-E (2).pdf" class="style103">Bulletin # 22 -July 2010</a><br>
  <a href="../../pdf/Bulletin 21-June 10-E.pdf" class="style103">  Bulletin # 21 -June 2010</a><a href="../../pdf/Bulletin 14-Oct 09.pdf" class="style103"><a href="../pdf/Bulletin 14-Oct 09.pdf" class="style103"></a></a></span><span class="style107"><a href="../../pdf/Bulletin 20-May 10-E.pdf" class="style103"><br>
  Bulletin # 20 -May 2010</a><a href="../../pdf/Bulletin 14-Oct 09.pdf" class="style103"><a href="../pdf/Bulletin 14-Oct 09.pdf" class="style103"><br>
  </a><a href="../../pdf/Bulletin 19-April 10.pdf" class="style103">Bulletin # 19 -April 2010 </a></span><span class="style107"><a href="../../pdf/Bulletin 18-Mar 10.pdf" class="style103"><br>
  Bulletin # 18 -March 2010</a></span><span class="style107"><a href="../../pdf/Bulletin 17-FEB 10 E.pdf" class="style103"><br>
  Bulletin # 17 -Feb 2010</a></span><span class="style107"><a href="../../pdf/Bulletin16-Dec09F.pdf" class="style103"><br>
  Bulletin # 16 - Dec 2009 </a></span><span class="style107"><a href="../../pdf/Bulletin 15-Nov 09.pdf" class="style103"><br>
  Bulletin # 15 - Nov 2009 </a><br>
  </span><span class="style103"><a href="../../pdf/Bulletin 14-Oct 09.pdf" class="style103">Bulletin # 14 - Oct 2009 <br>
  </a><a href="../../pdf/Bulletin 13-Sept 09.pdf" class="style103"> Bulletin # 13 - Sept 2009</a><a href="../../pdf/Bulletin 12-August 09 _2_.pdf" class="style103"><br>
  Bulletin # 12 - Aug 2009</a><br>
  <a href="../../pdf/Bulletin 11-July 09 E.doc" class="style103">Bulletin # 11 - July 2009</a> <br>
  </span><br>
  <br>
<img src="../../graphics/placeholder.jpg" width="131" height="29"></span></p>
<!-- #EndLibraryItem --><span class="style93"><br>  
                    </span><br>
                </ul></td>
           </tr>
            
          </table></td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td height="53"></td>
          <td>&nbsp;</td>
          <td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
            <!--DWLayoutTable-->
            <tr>
              <td width="190" height="158" valign="top" background="../../graphics/newback.jpg">&nbsp;</td>
           </tr>
          </table></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td height="105"></td>
          <td background="../../graphics/backnew.jpg">&nbsp;</td>
          <td></td>
          <td></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td height="18"></td>
          <td background="../../graphics/backnew.jpg">&nbsp;</td>
          <td>&nbsp;</td>
          <td></td>
          <td></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td height="18"></td>
          <td background="../../graphics/backnew.jpg">&nbsp;</td>
          <td>&nbsp;</td>
          <td colspan="5" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="32" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
      <!--DWLayoutTable-->
      <tr>
        <td width="901" height="32" valign="top" background="../../graphics/back_cehn.jpg"><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <!--DWLayoutTable-->
          <tr>
            <td width="901" height="1" background="../../graphics/back_cehn.jpg"></td>
         </tr>
        </table></td>
     </tr>
      
      
    </table></td>
  </tr>
  
  
</table>


</body>


</html>