";
		echo "
The following field(s) can not be blank:

";
		$breturn=0;
	}

	$qname = "SELECT * FROM consumers WHERE email_addr='" . trim($email_addr) . "'";
	$result=mysql_query($qname);
	if (mysql_affected_rows()>0){
		$bemailexists=1;
		if($breturn){
			echo "

";
        		echo "

";
			$breturn=0;
		}
	}
	mysql_close();

	$newemail_addr = "_".$email_addr;
    if (strpos($newemail_addr, "@")==0){
		$bnoatsign=1;
		if($breturn){
			echo "
";
        	echo "

";
			$breturn=0;
		}
	}

	if ($country=="USA"){
		if (strlen($zip)==5){
			for($i=0;$i<5;$i++){
				if (ereg("[0-9]", substr($zip, $i, 1))!=1){               
					$binvaliduszip=1;
				}
			}
		}elseif(strlen($zip)==10){
			for($i=0;$i<10;$i++){
				if ($i!=5){
					if (ereg("[0-9]", substr($zip, $i, 1))!=1){           
						$binvaliduszip=1;
					}
				}
			}
		}else{
			$binvaliduszip=1;
		}
		if ($binvaliduszip==1){
			if($breturn){
				echo "
";
					echo "

";
				$breturn=0;
			}
		}
	}elseif($country=="Canada"){
		if (strlen($zip)==6){
			for($i=0;$i<6;$i++){
				if ($i%2==0){
					if (ereg("[A-Z]|[a-z]", substr($zip, $i, 1))!=1){
						$binvalidcazip=1;
					}
				}else{
					if (ereg("[0-9]", substr($zip, $i, 1))!=1){       
						$binvalidcazip=1;
					}
				}

			}
		}else{
			$binvalidcazip=1;
		}
		if ($binvalidcazip==1){
			if($breturn){
				echo "";
				echo "
\n";
			}
		}
	}

	if ($breturn){
	}else{
		if (empty($first_name)){
			echo "         First Name: 
\n";
		}else{
			echo "         First Name: 
\n";
  		}
		if (empty($last_name)){
			echo "          Last Name: 
\n";
		}else{
			echo "          Last Name: 
\n";
  		}
		if (empty($email_addr)){
			echo "             E-mail: 
\n";
		}else{
			if ($bemailexists or $bnoatsign){
				echo "             E-mail: 
\n";
			}else{
				echo "             E-mail: 
\n";
			}
			if ($bemailexists){
				echo "             A subscriber already exists with this e-mail address.
\n";
				echo "             Please select another e-mail address.
\n";
			}
			if ($bnoatsign){
				echo "             The e-mail address must contain the '@' character.
\n";
			}
		} 

		#Get the list of countries from the database.
		mysql_connect($hostname);
		mysql_select_db($dbname);
		$sql = "SELECT DISTINCT country FROM countries";
		$result = mysql_query($sql);
        echo "            Country: ";
		while ($myrow = mysql_fetch_array($result)) {
			if ($myrow[country]==$country){
				echo "" . $myrow[country] . "";
			}else{
				echo "" . $myrow[country] . "";
			}
		}
		mysql_close();
		echo "
";
  		echo "\n";
		if (empty($zip) and ($country=="USA" or $country=="Canada")){
			echo "    Zip/Postal Code: 
";
		}elseif ($binvaliduszip==1){
			echo "    Zip/Postal Code: 
";
			echo "             The zip code field must be in one of the two
";
			echo "             following formats: ##### or #####-####.
";
		}elseif ($binvalidcazip==1){
			echo "    Zip/Postal Code: 
";
			echo "             The zip code field must be a six character
";
			echo "             string in the following format:  letter,number
";
			echo "             letter,number,letter,number.
";
		}else{
			echo "    Zip/Postal Code: 
";
		}
  		echo "\n";
		echo "            Please send me the HTML version\n\n";
		echo "            Please send me the plain text version\n";
		echo "";
		
		echo "
";
?>
                    
HTML Newsletter: Email newsletter format 
                      including pictures size, bold & Italics). This formatting 
                      is correctly displayed in most email programs. However, 
                      some email programs (such as AOL and some older email programs) 
                      are not capable of displaying pictures and other HTML formatting. 
                      If you normally receive email messages with pictures, links 
                      and formatted text, or you use Netscape Navigator or Internet 
                      Explorer to view your email, this format should work fine 
                      for you, otherwise you should select the plain text version 
                      of this newsletter. 
                    
Please check that 
                      the above information -- especially your e-mail address 
                      -- is correct before signing up for To Your Health.
                    

 
  
  

                      
Please note that ChiroWeb.com does not share, rent or 
                        sell e-mail information with anyone. For more information, 
                        please see our privacy 
                        policy. 
                    

 

";
		echo "
";

	}
	return $breturn;
}
?> 




 

  
 
    

  
  
 
    

    
 
    
 
      
 
      
To Your Health Newsletter
      
A free newsletter designed to help you live 
        a healthier, happier life.
      
Click 
        here to view the current on-line TYH Newsletter.

      
Please note that ChiroWeb.com does not share, rent 
        or sell e-mail information with anyone. For more information, please see 
        our privacy policy.
      0){
				echo "You have been successfully added as a To Your Health newsletter subscriber.";
				echo "The latest copy of To Your Health should be mailed to you shortly.";
#			}
#			mysql_close();
		}
	} else{ 
			#Get the list of countries from the database.
			mysql_connect($hostname);
			mysql_select_db($dbname);
			$sql = "SELECT DISTINCT country FROM countries";
			$result = mysql_query($sql);
			
?> 
      

        

         First Name: 

          Last Name: 

             E-mail: 

            Country: 

" . $myrow[country] . "";
				}else{
					echo "" . $myrow[country] . "";
				}
			}
			mysql_close();
?>
			
			
    Zip/Postal Code: 
    
            Please send me the HTML version
            
            Please send me the plain text version
         
        
HTML Newsletter: Email newsletter format including 
          pictures size, bold & Italics). This formatting is correctly displayed 
          in most email programs. However, some email programs (such as AOL and 
          some older email programs) are not capable of displaying pictures and 
          other HTML formatting. If you normally receive email messages with pictures, 
          links and formatted text, or you use Netscape Navigator or Internet 
          Explorer to view your email, this format should work fine for you, otherwise 
          you should select the plain text version of this newsletter. 
        
Please check that the above 
          information -- especially your e-mail address -- is correct before signing 
          up for To Your Health.
        
Learn 
          how doctors can provide this newsletter for your patients.
        

        
          
 
            
            
          
        
        

        

        

        
The To Your Health e-mail newsletter will keep you informed 
          of the latest developments in the changing world of health care. With 
          a strong focus on wellness and natural healing, To Your Health 
          brings you fully referenced research developments that will give you 
          the information you need to make the best health care decisions for 
          you and your loved ones.