<?php include 'send_contact.php' ?>

<?php

$host="localhost"; // Host name 
$username="**********"; // Mysql username 
$password="********"; // Mysql password 
$db_name="barrie_contactinfo"; // Database name 
$tbl_name="contact_info"; // Table name 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form 
$name=$_POST['fullname'];
$email=$_POST['email'];
$hear=$_POST['select2'];

//Check to see if values already exist in the database
$check= mysql_query("SELECT FullName FROM \"$tbl_name\" WHERE FullName=\"$name\"");
$returned = mysql_fetch_array($check);
if(!empty($returned))
    {
    header("Location: error-nameexists.php");
    mysql_close();
    Die();
    }
else {
//Check to see if email exists in the database
$check = mysql_query("SELECT Email from users WHERE Email=\"$email\"");
$returned = mysql_fetch_array($check);
if(!empty($returned))
    {
    header("Location: error-nameexists.php");
    mysql_close();
    Die();
    }




//****Above is the part I am not sure about, basically I'm not sure abot the mysql_query statement.**********  




// Insert data into mysql 
$sql="INSERT INTO $tbl_name(FullName, Email, Hear)VALUES('$name', '$email', '$hear')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message. 
if($result){
echo "Thank you for your interest in the Barrie Men's Hockey League.  We will be in touch with you as soon as possible.<br><br><a href='index.html'>Back to main page</a>";
}

else {
echo "ERROR";
}
}

// close connection 
mysql_close();
?>

//mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_connect( $host, $username, $password ) or die( "cannot connect" ); 

// Get values from form
if( isset($_POST['fullname'])  &&  $_POST['fullname']=trim($_POST['fullname']) )
{
    // remove slashes that PHP may have inserted to this value.
    if( get_magic_quotes_gpc() )
        $_POST['fullname'] = stripslashes( $_POST['fullname'] );
}
//$name=$_POST['fullname'];