Welcome to the TRT

//see if the form has been submitted
if ((isset($_REQUEST['register_action'])) && ($_REQUEST['register_action']=="send"))
{
// start by getting sent variables to pre-fill the form if there is an error
$error="";
$first_name=$_REQUEST['first_name'];
$last_name=$_REQUEST['last_name'];
$email_address=$_REQUEST['email_address'];
$confirm_email_address=$_REQUEST['confirm_email_address'];
$country=$_REQUEST['country'];
$receive_email_updates=$_REQUEST['receive_email_updates'];
$toured_with_trt=$_REQUEST['toured_with_trt'];
$toured_where=$_REQUEST['toured_where'];
$toured_year=$_REQUEST['toured_year'];
$touring_in_future=$_REQUEST['touring_in_future'];
$rugby_experience=$_REQUEST['rugby_experience'];
$volunteering=$_REQUEST['volunteering'];
$known_about_trt=$_REQUEST['known_about_trt'];
$how_did_you_hear=$_REQUEST['how_did_you_hear'];

//now check for errors
if ($first_name=="")
$error.="Please enter your first name
“;

if ($last_name==”")
$error.=”Please enter your last name
“;

if ($email_address==”")
$error.=”Please enter your email address
“;

if ($confirm_email_address==”")
$error.=”Please confirm your email address
“;

if ($email_address!=$confirm_email_address)
$error.=”Email and confrim email don’t match
“;

// check we aren’t already registered
mysql_connect($server,$username,$password);
mysql_select_db($db);
$sql=”SELECT * FROM `registered_users` WHERE `email_address` = ‘”. mysql_real_escape_string($email_address).”‘”;
$rs_results = mysql_query($sql) or die (“mysql_query failed: ” . mysql_error());

if (mysql_num_rows($rs_results)!=0)
$error.=”Email address already registered
“;

//convert check boxes to 1/0
if ($receive_email_updates==”on”)
$receive_email_updates=1;
else
$receive_email_updates=0;

if ($touring_in_future==”on”)
$touring_in_future=1;
else
$touring_in_future=0;

if ($volunteering==”on”)
$volunteering=1;
else
$volunteering=0;

}
else
{ // nothing sent so we set variables to blank
$error=”";
$first_name=”";
$last_name=”";
$email_address=”";
$confirm_email_address=”";
$country=”";
$receive_email_updates=”";
$toured_with_trt=”";
$toured_where=”";
$toured_year=”";
$touring_in_future=”";
$rugby_experience=”";
$volunteering=”";
$known_about_trt=”";
$how_did_you_hear=”";
}

// if the form is submitted and we have no errors….
if (((isset($_REQUEST['register_action'])) && ($_REQUEST['register_action']==”send”)) && ($error==”"))
{
// add to the database

mysql_connect($server,$username,$password);
mysql_select_db($db);

$sql=”INSERT INTO `registered_users` (`first_name`,`last_name`,`email_address`,`country`,`receive_email_updates`,`toured_with_trt`,`toured_where`,`toured_year`,`touring_in_future`,`rugby_experience`,`volunteering`,`known_about_trt`,`how_did_you_hear`,`unregister_key`) VALUES (“;
$sql.=”‘”. mysql_real_escape_string($first_name).”‘,”;
$sql.=”‘”. mysql_real_escape_string($last_name).”‘,”;
$sql.=”‘”. mysql_real_escape_string($email_address).”‘,”;
$sql.=”‘”. mysql_real_escape_string($country).”‘,”;
$sql.=”‘”. $receive_email_updates.”‘,”;
$sql.=”‘”. $toured_with_trt.”‘,”;
$sql.=”‘”. mysql_real_escape_string($toured_where).”‘,”;
$sql.=”‘”. mysql_real_escape_string($toured_year).”‘,”;
$sql.=”‘”. $touring_in_future.”‘,”;
$sql.=”‘”. mysql_real_escape_string($rugby_experience).”‘,”;
$sql.=”‘”. $volunteering.”‘,”;
$sql.=”‘”. mysql_real_escape_string($known_about_trt).”‘,”;
$sql.=”‘”. mysql_real_escape_string($how_did_you_hear).”‘,”;
$sql.=”‘”. md5(uniqid()).”‘)”;

mysql_query($sql) or die (“mysql_query failed: ” . mysql_error());
//mysql_close();
// and say thanks – its only polite!
?>